Menu

Uncategorized

convert fahrenheit to celsius3

How to Convert Fahrenheit to Celsius or Kelvin in Microsoft Excel

July 20, 2019

This post will guide you how to Convert Temperatures among Fahrenheit, Celsius, and kelvin using a formula in Microsoft Excel. How do I convert Fahrenheit to Celsius in Excel 2013/2016. How to convert degrees Fahrenheit to degrees Celsius in Excel. The Fahrenheit unit is a measure of temperature primarily used in the United States, but… read more »

change orientation of worksheet1

How to Change the Orientation of Worksheet in Excel

February 1, 2019

This post will guide you how to change the default Portrait orientation to Landscape page orientation in your worksheet in Excel. Change the Orientation of Worksheet When you have a list of data with lots of columns, you can try to change the orientation to Landscape page orientation. Do the following steps: #1 go to… read more »

limit formula result2

Limit Formula Result to Maximum or Minimum Value

July 31, 2018

This post will guide you how to limit formula result to a maximum or minimum value in excel. For example, if you want to limit the results of a formula to a maximum value of 200, how to this this in excel. How do I return a formula result only within a specified minimum or… read more »

insert delete comments1

Insert or Delete Comment using Shortcut

July 17, 2018

This post will guide you how to use shortcut to insert or delete a comment that exists in the active cell in excel. How do I quickly insert or delete a comment in an active cell with shortcut keys in excel. Add comment in Windows If you want to quickly add or edit comments in… read more »

Excel SWITCH Function

April 28, 2018

This post will guide you how to use Excel SWITCH function with syntax and examples in Microsoft excel. Description The Excel SWITCH function compares one value against a list of values, and returns the result corresponding to the first matching value. A default value can be returned if none of the supplied values match the… read more »

excel roundup examples5

Excel ROUNDUP Function

March 29, 2018

This post will guide you how to use Excel ROUNDUP function with syntax and examples in Microsoft excel. Description The Excel ROUNDUP function rounds the number up to a specified number of decimal places. It will round away from 0. The ROUNDUP function is a build-in function in Microsoft Excel and it is categorized as… read more »

fill empty blank cell with value2

Fill Blank Cells with specific value (0 or null)

January 5, 2019

This post will teach you how to fill all blank cells with specific value, such as: 0 or any other values in excel. How to locate all blank cells and then fill in all the blanks with any specific value. The below will guide you to fill empty cells with different ways in excel 2016… read more »

Sidebar