Tuesday, January 4, 2011

Copy as Picture in Excel

Excel2007:

Want to copy texts and graphs as picture? Here's how.

1. Click Paste -->As Picture--->Copy as picture.
2. A dialog box will then pop-up, giving you a choice to copy as picture or bitmap and if copied as shown on screen or when printed.

3. Choose between the appearance and the format
4. Paste as usual.
5. Done!

Excel 2010:

1. Go to home tab, copy, the select "copy as picture"

2. A dialog box will then pop-up, giving you a choice to copy as picture or bitmap and if copied as shown on screen or when printed.

3. Choose between the appearance and the format
4. Paste as usual.
5. Done!



Excel 2003:

There is a secret menu for this and this is how to get it.
1. Press the shift button while clicking on the Edit menu. There, a new menu will come up - "Copy as picture".
2. Click on this. The same popup dialog box will appear.
3. Choose between the appearance button (as printed or as seen on screen) and format (as picture or bitmap).
4. Paste as usual.
5. Done!

What for? Well, this will ensure that your graphs and your text will be consistent in its size and formatting when you paste it in the same sheet or on another office document such as word or PowerPoint.
This could be very useful when doing reports and presentations.

Happy computing!

Monday, January 3, 2011

Shortcut to Format any Number in Excel

Here's some shortcut to easily convert a number to any format.
First, when you add a number in an excel cell, it defaults to a "general" format - "1234". To quickly change it to a "number" format - 1,234.00 here's what you do:

                      1. Click the cell with the number
                      2. Press Ctl-Shift-1
                      3. Done!

Easy!

Other combination and formatting results are as follows:

                     Ctl-Shift-2: Hour - 12:00AM
                     Ctl-Shift-3: Date -  18-May-03
                     Ctl-Shift-4: Dollar - $1,234.00
                     Ctl-Shift-5: Percent -1234%
                     Ctl-Shift-6: Scientific Notation -1.23E+03

Happy Computing!

Hiding the Excel 2007 Ribbon Shortcut

Using a netbook and want to save some screen space? Try to hide the "Ribbon". The ribbon is where the menus in excel 2007 are.

To quickly hide and unhide it, just use Ctl-F1. That's it!
Happy computing!
Related Posts Plugin for WordPress, Blogger...