Multiple Spreadsheets

The_Hurricane

Hi All,

I have several spreadsheets loaded and in the past I would have used ALT+Tab to quickly flick between each one, however today I'm unable to do this and I have to minimise one spreadsheet and maximise another before I can view it. Is there anyway around this?

Thanks

WTFH

What operating system are you using?
What spreadsheet software?
Are they seperate files, or seperate sheets within the one file?

Jivesinger

Does Ctrl-Tab work?

If you're using Windows, then generally, Alt-Tab switches between applications, and Ctrl-Tab or Ctrl-F6 switches between multiple windows within one application.

If you're using Excel, then depending on a setting within options called "Windows in Taskbar", and whether you have each spreadsheet maximised or if you have several spreadsheets within one overall Excel window, it may or may not treat each spreadsheet as a separate application. Accordingly Alt-Tab may or may not work.

esuhl

Both Alt-TAB and Ctrl-TAB work for me (switch between open workbooks) in Excel 2003.

If you want to switch between different sheets on the same workbook, try Ctrl+PageUp and Ctrl+PageDown.

Jivesinger

esuhl wrote: »

Both Alt-TAB and Ctrl-TAB work for me (switch between open workbooks) in Excel 2003.

Yes but it depends how you've set up the "Windows in Taskbar" setting. I imagine it is ticked for you (in Tools | Options)

You can change things so that Alt-Tab won't do that - hence the OP's query.

As it happens I have Excel 2003 set in such a way that Alt-Tab doesn't change workbooks.