flipping columns & absolute references

  • Thread starter Thread starter mokey
  • Start date Start date
M

mokey

Two things:
1.I would like to easily be able to switch the positions
of two columns so that column A would become column B and
column B would become column A. Is there a way without
copying and pasting? A sort procedure that I've
overlooked?

2.Is there a way to toggle absolute vs. relative cell
references when entering a formula in excel. I need to
keep the range references in my cells absolute when I copy
the formula down. Right now, I'm going back into my
completed formula and manually putting in the dollar signs.

Thanks for the help!!
 
1. You can move columns around using the mouse and the 'ctrl' and 'shift' keys. Select the entire column. Grab the right or left side of the selected column. While holding the 'shift' key, move your mouse to the new location. This will move the column and insert it into the new location. The 'ctrl' key will COPY it over the existing column

2. The F4 key will toggle through the different reference styles. If you sweep the formula it will change all reference at the same time

Good Luck
Mark Graesse
(e-mail address removed)

----- mokey wrote: ----

Two things
1.I would like to easily be able to switch the positions
of two columns so that column A would become column B and
column B would become column A. Is there a way without
copying and pasting? A sort procedure that I've
overlooked

2.Is there a way to toggle absolute vs. relative cell
references when entering a formula in excel. I need to
keep the range references in my cells absolute when I copy
the formula down. Right now, I'm going back into my
completed formula and manually putting in the dollar signs

Thanks for the help!
 
Back
Top