Once you have gone into Print Layout view or Print Preview when working with an Excel worksheet, when you return to Normal view, you will see dashed lines showing where the page breaks will be in the worksheet. 113 more words
Tags » Microsoft Excel 2010
When you see a little green triangle at the top left of an Excel cell, it is giving you a warning message to say there may be some inconsistency in your formulas. 104 more words
If you want to set the same zoom level for several worksheets in a workbook, you can do this all at once by first grouping the worksheets together. 201 more words
I was recently asked whether you could incorporate more than one Excel worksheet into a single pdf.
To do so, first group the worksheets – if they are not next to each other, select the first one, then holding down the… 142 more words
If you have a column of credit card numbers or phone numbers where blanks have been included and you want to remove the blanks, the… 119 more words
Usually when working with large numbers it is useful to see the comma separator to be able to more clearly read the numbers.
I was recently asked how to get rid of the commas. 90 more words
I was recently asked how to create a checkbox which could be copied and pasted into a range of cells in Excel.
To work with checkboxes, you first have to have the… 214 more words