Tech Tips Home
The Best Tech Tips And Daily Deals
Newsletter On The Internet!

Shop online 24hrs a day or call us Mon-Fri
8:30AM-4:30PM EST - 1-800-915-2088
WorldStart Tech Tip And Store Search
Email: Password: Login Remember Me

Like what you see here? Subscribe to the Tech Tips newsletter!   Email: Subscribe

More or Less

Friday, January 18th, 2008 by | Filed Under: MS Excel, MS Office Help
 
Loading...


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

Comments are closed.

Like what you see here? Subscribe to the Tech Tips newsletter!   Email: Subscribe

More or Less?

Friday, December 1st, 2006 by | Filed Under: MS Excel, MS Office Help
 
Loading...


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

Comments are closed.

Like what you see here? Subscribe to the Tech Tips newsletter!   Email: Subscribe

More or Less?

Tuesday, November 16th, 2004 by | Filed Under: MS Office Help
 
Loading...


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…

Comments are closed.

Like these tips? Get them for FREE in your email!

WorldStart's Tech Tips Newsletter

  • Tech Tips Daily - Become a tech pro! Get the very best tech and computer help sent directly to your email every weekday!

  • Tech Tips Weekly - If you don't want our Tech Tips newsletter every day, then sign up for this weekly newsletter to get the best information of the week. Sent on Fridays.

Other Newsletters

  • WorldStart's Daily Deals - Every week, we send out great deals in our Daily Deals newsletter. Many of these deals are exclusively for our Daily Deals newsletter subscribers and can't be found with our regular specials.

  • Just For Grins - Each issue includes a couple clean jokes, some funny quotes, and a hilarious reader's story. Newsletter is sent five days a week.


Enter Email Address:

Subscribe

Your e-mail address is safe with us!
We only use it to send you the newsletters you request. It is NEVER disclosed to a third party for any reason, ever! Plus, if you decided you don't like our newsletters (don't worry, you'll love them), unsubscribing is fast and easy.

Free Newsletter Signup



Tech Tips Daily

Become a tech pro! Get the very best tech and computer help sent directly to your email every weekday!

Tech Tips Weekly

The week's best in tech and computer help. Get your issue sent to your email every Friday!

WorldStart's Daily Deals

The very best deals on the Internet! Get a new set of incredible sales every day of the week!

Just For Grins

Clean jokes, funny quotes, and hilarious comics. Sent 5 times a week straight to your email.


Subscribe


Love Worldstart? Refer A Friend!

WorldStart's Premium Membership

Tip Archive


Categories:
Archives: