asked on

in excel I want to hide the same colums

I keep on pullng down spreadsheets, three or 4 of them they are tasks I need to complete.

Usually they have too much information in them. keep on going in and hiding the same cells every time I open up the boss's copy on the sharepoint.

Is there a way to hide the same colums each time I open the sheet ? I would like to apply the changes after I open up the sheet

I can not alter the bosses copy with the hiding. :)

SOLUTION

Ardhendu Sarangi

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

Ardhendu Sarangi

if u can give us specific columns to hide and the exact requirements, i can create something for you...

SOLUTION

dlmille

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

Chris Bottomley

How would you identify one of your bosses workbooks?

Chris

SOLUTION

dlmille

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

TIMFOX123

ASKER

I am working on this but I have a very big priority in my job right now sooo...

I may try to make a sheet and paste in the bosses stuff in it.

run a macro to make a "veiw"

what do you think. Is there a easy way to take the data an nothing else. ?

You all have been grand!!

dlmille

It would be easier to hide the columns - but, you're the judge and have to live with the solution!

Good Luck!

Dave

ASKER CERTIFIED SOLUTION

dlmille

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

TIMFOX123

ASKER

thank you all.

I had a whole army of help.