- Worldstart's Tech Tips And Computer Help - http://www.worldstart.com -

More or Less

Posted By On January 18, 2008 @ 2:37 PM In MS Excel,MS Office Help | Comments Disabled

More or Less

For my readers who are fairly new users of MS Excel, here’s a quick, yet infinitely useful tip for changing the number of decimal places displayed in one of your cells!

You’re looking for these two buttons located on the Formatting toolbar or in Excel 2007, they’re on the Home ribbon, Number section:

(If you’re using older versions of Excel and you don’t see them, go to the View menu, Toolbars submenu and choose Formatting from the list).

The button on the left will add decimal places to numbers in highlighted cells.

The button on the right will reduce the number of decimal places in highlighted cells. (As decimal places are reduced, the value displayed in the cell is rounded. However, if you take a look in the formula bar, you’ll see that Excel still has the exact value stored away safely in its memory).

More or less is just a click away!

~ April

More or Less?

Posted By On December 1, 2006 @ 2:52 PM In MS Excel,MS Office Help | No Comments

More or Less?

What do you do if you need another worksheet in your workbook?

Quick and easy solution: Go to the Insert menu, Worksheet choice.

Done! The worksheet is inserted to the left of whatever sheet you were currently working on.

Trying to insert several worksheets at once?

Hold the Shift key down and select the tabs of several worksheets (the number you’re trying to insert). Then go to the Insert menu, Worksheet choice. (Just think how awesome it would be if we had an Insert menu for some extra zeros in the old paycheck!)

What do you do if you want to remove some worksheets from the file?

Another quick and easy solution: Select the tab of the worksheet to be deleted and then go to the Edit menu, Delete Sheet choice. You will be asked to confirm your choice to finish the process since this cannot be undone.

Want to delete several worksheets? Simply select the tabs of all the sheets you wish to delete. Then go to the Edit menu, Delete Sheet choice and confirm your decision. (Remember, the Shift key will select consecutive sheets and the Control key will select non-consecutive sheets).

For the readers with limited storage capacity, the deletion of unused sheets in a workbook will make the file smaller.

That’s it! Having exactly what you need when you need it isn’t that difficult. At least in Excel.

Too bad we can’t have Edit and Insert menus on a few things around the house, huh?!

~ April

More or Less?

Posted By On November 16, 2004 @ 3:07 PM In MS Office Help | No Comments

More or Less?

What do you do if you need another worksheet in your workbook?

Quick and easy solution: Go to the Insert menu, Worksheet choice.

Done! Worksheet inserted to the left of whatever sheet you were currently working on.

Trying to insert several worksheets at once?

Hold the Shift key down and select the tabs of several worksheets (the number you’re trying to insert). Then go to the Insert menu, Worksheet choice. (Just think how awesome it would be if we had an insert menu for some extra zeros in the old paycheck…)

What do you do if you want to remove some worksheets from the file?

Another quick and easy solution: Select the tab of the worksheet to be deleted then go to the Edit menu, Delete sheet choice. You will be asked to confirm your choice to finish the process since this can not be undone.

Want to delete several worksheets? Simply select the tabs of all the sheets you wish to delete. Then go to the Edit menu, Delete sheet choice and confirm your decision. (Remember – the Shift key will select consecutive sheets and the Control key will select non-consecutive sheets.)

For the readers with limited storage capacity, the deletion of unused sheets in a workbook will make the file smaller.

That’s it. Having exactly what you need when you need it isn’t that difficult, at least in Excel.

Too bad we can’t have Edit and Insert menus on a few things around the house…


Article printed from Worldstart's Tech Tips And Computer Help: http://www.worldstart.com

URL to article: http://www.worldstart.com/more-or-less/