I am an intermediate level MS Excel user. I often use my spreadsheet and would like to see different views at the click of a button. By this, lets say I have columns A through Z. I know I can manually MOVE, say columns C, G, L, and P to be the first 4 columns, into position A,B,C,D. And I can then move the new A, B, C, D back to C,G,L,P when I am done.

However, is there something like a "saved view" or "saved display" that I can use as a shortcut to swap the "views" of my data back and forth?

Have you trying making a macro for this?

The way I would do this is to use Separate Worksheets.

I a different sheet enter the following into the first 4 coulmns:

Col A: =Sheet1:C1
Col B: =Sheet1:G1
Col C: =Sheet1:L1
Col D: =Sheet1:P1

When you switch to that sheet you will see the columns in that order.

Try looking at the group and outline option under the DATA menu. This will let you select a certain number of columns or rows and then "group" them or "ungroup" them. You will see a plus/minus box above the spreadsheet for these rows- clicking it will hide/unhide these rows easily just like the treeview in windows.

If I understand your question properly <you want to view both the original spreadsheet a 2nd spreadsheet with new data ,at the same time >, you can use the "window" tab on your excel file.
Just click on "Window", the select "Arrange" .You can then view on your screen all the spreadsheets as you have opened ( vertically, horizontally , tiled etc.)You can then swap between files seeing the results of any changes you have made , remember if you have the files linked , changes in one file will be reflected in the other .
Hope this helps...
Fergus

ScottGem, I tried your suggestion above and it did not do anything, meaning it did not "grab" or "capture" the values in sheet 1 and put them into sheet 2. Maybe I am not understanding.

zix, I think this is what ScottGem was explaining.

Whoops, looks like I used the wrong character (:) instead of (!) to separate the sheet and cell address. Col's sample has the correct syntax.

Frankly, however, an "intermediate Excel user" should have caught the error and know how to reference cells.