Tags » Microsoft Excel 2010

Microsoft Excel – getting rid of page break lines

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

Microsoft Excel

Microsoft Excel – getting rid of green triangle indicator

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

Microsoft Excel

Microsoft Excel – setting same zoom level for several worksheets

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

Microsoft Excel

Microsoft Excel – creating a pdf from more than one worksheet in a workbook

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

Microsoft Excel

Microsoft Excel – removing blanks from credit card numbers, phone numbers, etc.

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

Microsoft Excel

Microsoft Excel – removing comma separators from numbers

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

Microsoft Excel

Microsoft Excel – creating a checkbox for several cells in a column

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

Microsoft Excel