Preview your worksheet before you print

Preview your worksheet before you print: You can see exactly how your worksheet will look on the printed page by using the Print Preview feature. In terms of saving you time and paper, the preview is your most valuable printing tool. You can even make certain changes within the Print Preview, like clicking on and dragging the print margins to make them wider or narrower. Check the preview as you change printing and layout options to make sure your spreadsheet looks the way you want.

Read More

nsert non-keyboard symbols

Insert non-keyboard symbols: Using Excel 2010, you can insert special symbols that are otherwise not found on the keyboard, such as the trademark sign (™) or the copyright sign (©). In order to do this, click the Insert tab and in the Symbols group, click Symbol. This will cause the Character Map to appear. Select your desired symbol and click Insert to put it in your worksheet.

Read More

Check your VBA code for errors

Check your VBA code for errors: Visual Basic includes a syntax-checking feature that checks each statement as you enter it for syntax errors, such as a misspelled keyword or missing separator, and alerts you if there are errors. It also translates the code to an internal form if the syntax is correct, which speeds the transition to run time. This feature is turned on when you first start, but you can turn it off if you prefer to write code without being alerted to errors as they occur. To enable syntax checking, click Options in the Tools menu. Select the Editor tab, then the ‘Auto Syntax Check’ check box. After that, click OK.

Read More

Rearranging rows by using Word:

Another very handy tip to know is how to quickly and easily shift rows around when you’re sorting data on an Excel sheet – for example, if you want to group names and addresses. Of course, you could write a complex statement to achieve this, but for a small list it’s much quicker just to shift the rows around – and by far the best way to do it is to move the data to Word, use Word commands, and then paste it all back to Excel:


1. Copy the rows and columns which contain the relevant data and paste it all into a Word document. It will look like a table and retain all your formatting


2. Select entire rows or parts of rows..


3. Press SHIFT-ALT-UP-ARROW and SHIFT-ALT-DOWN-ARROW to slide them up and down.


4. Once the rows are as you want them, you can paste them back into Excel.


5. (Be careful that you put them back in exactly the right position!)

Read More