Quick Tip for Microsoft Excel 2010 How to use Absolute Cell References in Excel 2010 Using AutoFill to copy formulas is a great way to save time, but the cell references in the original formula do not always need to be adjusted. There are some situations where a cell reference needs to remain constant. For example: Look […]
Quick Tip for Microsoft Excel 2010 Here is an introduction to Formulas in Microsoft Excel 2010. A Formula is the term used for a calculation in your spreadsheet. A formula performs calculations or other actions on the data in your worksheet. A formula always starts with an equal sign (=), which can be followed by numbers, […]
Quick Tip for Microsoft Excel 2010 Here I show you how to copy Formatting using Autofill in Microsoft Excel 2010. AutoFill also allows you to copy formats from one cell to another. To copy formatting using Autofill 1. Format the content in your first cell. 2. Position your cursor so it hovers over the bottom right […]
Quick Tip for Microsoft Excel 2010 Here I show you how to Create Cell Styles in Microsoft Excel 2010. You can create your own Cell Style to allow you to rapidly format your workbook consistently. To create a cell style 1. Format a cell/some cells in the style you would like to add to Cell Styles […]
Quick Tip for Microsoft Excel 2010 Here are some steps on how to apply Cell Styles in Microsoft Excel 2010 Cell styles are pre-set formats for cells. They can be reused to help your sheet’s formatting look consistent. Select the cells you would like to apply a style to (1) Go to the Styles group on […]
Quick Tip for Microsoft Excel 2010 Here is how to set the Page Margins in Microsoft Excel 2010 1. Go to the Page Layout tab on the ribbon 2. Go to the Page Setup group 3. Click on Margins (1) 4. Choose Normal, Wide or Narrow (2) To set custom margins using sizing you set yourself […]