Aug 31, 2011 - Select the cell with the formula; Point to the fill handle, at the bottom right of the. How can you quickly enter formulas in a column, if you're setting up a workbook, with lots of empty cells? For more data entry tips, go to the Data Entry page on my Contextures website. September 1, 2011 at 7:00 PM.
Related Articles
- 1 Get Rid of Unneeded Cells in Excel
- 2 Double Space in OpenOffice 3.4.1
- 3 Wrap Text in Microsoft Excel 2003
- 4 Add Shading in PowerPoint 2003
In Excel 2011 for Mac computers, Microsoft provides you with two different double underline styles that you can apply to cells on your business worksheets. The standard double underline adds two lines to the bottom of all contents in a cell, while the double accounting underline adds two lines to all contents of a cell except currency symbols.
1.Select the cell or range of cells containing the content you want to underline.
2.
Right-click anywhere in your selected cell or cells and click 'Format Cells' from the drop-down menu that appears. Excel displays the Format Cells dialog box.
3.Click the 'Font' tab on the Format Cells dialog box.
4.Click the 'Underline' pull-down menu and select either 'Double' or 'Double Accounting.' Click the 'OK' button. Excel inserts your chosen double underline.
References (1)
About the Author
Andrew Tennyson has been writing about culture, technology, health and a variety of other subjects since 2003. He has been published in The Gazette, DTR and ZCom. He holds a Bachelor of Arts in history and a Master of Fine Arts in writing.
Cite this Article Choose Citation Style
Tennyson, Andrew. 'How to Double Underline in Excel on Mac.' Small Business - Chron.com, http://smallbusiness.chron.com/double-underline-excel-mac-49105.html. Accessed 23 December 2019.
Tennyson, Andrew. (n.d.). How to Double Underline in Excel on Mac. Small Business - Chron.com. Retrieved from http://smallbusiness.chron.com/double-underline-excel-mac-49105.html
Tennyson, Andrew. 'How to Double Underline in Excel on Mac' accessed December 23, 2019. http://smallbusiness.chron.com/double-underline-excel-mac-49105.html
Note: Depending on which text editor you're pasting into, you might have to add the italics to the site name.
Deb is trying to AutoFill record numbers in a column of her worksheet; record 1 in the first cell, record 2 in the second cell, etc. The 'Enable Fill Handle' box is checked in Excel options. However, when she uses the AutoFill handle, it just pastes the same number in every cell. Deb is wondering how she can fix this.
Based upon the described behavior, it sounds like Deb is trying to use AutoFill to create a series (1, 2, 3, etc.) when she isn't giving AutoFill enough information to determine that is what she wants to do. For example, enter the value 1 into cell A1 and the value 2 into cell A2. If you select cell A2 and use the AutoFill handle to drag downward, what happens is that Excel fills each of the cells with the value 2. Why? Because you only started by selecting a single cell.
On the other hand, if you select cells A1:A2 and then drag down, AutoFill will increment the value placed into each of the cells. Why? Because it can analyze the information you started to enter in the cells and use it to determine how to fill the remaining cells with a series of values.
If, for some reason, you don't want to start with a selection of two cells, you could simply select one cell (A2) and hold down the Ctrl key as you drag the fill handle downward. AutoFill will override its normal determination (copy the selected value downward) by forcing a series of numbers into the filled cells.
If you're still having problems, make sure that your filters are clear. If filters are turned on, they may cause the same number to repeat, even when selecting more than one cell.