The Geeks' Den: Excel Shortcuts, Tutorials and how to open 2 or more Excel Files for Multi Monitors.

My blog has moved! Redirecting...

You should be automatically redirected. If not, visit http://www.igeekden.com and update your bookmarks.

Monday, October 26, 2009

Excel Shortcuts, Tutorials and how to open 2 or more Excel Files for Multi Monitors.

I have been using a bit of Excel at work and so I have typed up a shortcut list to make things easier.
Excel Shortcuts
Download this Shortcut sheet in Excel or PDF.

How to view 2 or more instances of Excel files over multiple monitors:

Excel 2003:
- Go to Tools -> Options -> General tab.
- Make sure the option, ‘Ignore other applications’ is checked. Now all the Excel files will be opened as separate instance and you can move the Excel files individually across the monitors.
Each time you open a file, excel will open blank so just go into the Open file again and open the file you want.

Excel 2007:
- Click the Office button -> Excel Options -> Advanced.
- Under General, check ‘Ignore other applications that use Dynamic Data Exchange’.

For other Tutorials on Excel Formula’s, head to Microsoft’s website: http://office.microsoft.com/en-us/excel/HP052001271033.aspx

No comments:

Post a Comment