excel

[weeds]

when in a cell is something i can turn on so that the column and row are highlighted so that i can input data quicker.......this will make it easier to line the member up with the merchandise that they have ordered

[WhiteD3]

Weeds, more info please. What's your question?

[p38arover]

Umm, I don't understand. When you are on a cell, the cell no. is shown on the the line above the sheet, e.g. D28. Also the D above the column is highlighted as is row no. 28.

If you need to go to a cell directly, press F5 then enter the cell no. and press enter.

[weeds]

yep yep yep

i see i'm in P19 and the P is orange and the 19 is also orange...all good

what i was hoping for is when in cell P19 the colum and row become shaded if you know what i mean so you can run you eye up and across quickly

[Bushie]

IF, and its probably a big IF, I'm getting the right vibes select the data you are working with and go to format|autoformat and pick one of the selections. (Maybe :eek::eek:)


Martyn

[100I]

If the cells you are mosts interested in are quite away from each other perhaps try 'Freeze panes'from the window menu. Follow?

[WhiteD3]

Kelvin,

I don't think you can do what you want to do without some VBA code. "Conditional Formating" is the closest you'll get.

[awabbit6]

If the cells you are mosts interested in are quite away from each other perhaps try 'Freeze panes'from the window menu. Follow?

This is what I do also. Some rows and columns (down the left and accross the top) will freeze in position while you can move the rest of the sheet over so that cells of intersts are adjacent while you work on them. The rows and columns that freeze will be dependent on which cell is currently selected. The frozen panes will be above and to the left of the selected cell.

[MickG]

Yep, freeze panes is your friend in this instance I would suggest....you can do it for both the X & Y axis so the headers and left vertical list remain on screen;)

[weeds]

yep freeze panes is good....thanks

i now have office 07 at home so nothing is int he same place as the older office

[WhiteD3]

yep freeze panes is good....thanks

i now have office 07 at home so nothing is int he same place as the older office

Yep, and you can't switch it to "classic" view either. I find it a total pain in the whatsit!

[awabbit6]

i now have office 07 at home so nothing is int he same place as the older office

It does take a bit of getting used to, but once you get the gist of how the layout of the menus works you can sort of guess where everything is and be right most times.