freeze panes

Public Schedule Face-to-Face & Online Instructor-Led Training - View dates & book

Forum home » Delegate support and help forum » Microsoft Excel Training and help » Freeze panes

Freeze panes

resolvedResolved · Medium Priority · Version 2007

Kaylie has attended:
Excel Intermediate course

Freeze panes

can i sort columns and tables while the freeze panes are on or do i need to remove them? also when i search on a spreadsheet for a name with a freeze pane in place it doesn't search from the top of the spreadsheet, why is that?

RE: freeze panes

1) Yes your sort feature will work fine when your freeze is on.

2) can you please tell me how you are searching for a name? do you mean by just scrolling or do you use another search tool?

Will be marked as resolved in 5 days

Notice: This is an automated message. Due to inactivity, this forum post will be marked as 'resolved' if there are no further responses in the next 5 days.

Thu 20 Dec 2012: Automatically marked as resolved.


 

Excel tip:

Hide separate columns in Excel 2010

If you want to hide columns not adjacent to each other for example, Columns A, C and E then:-

1) Click on the fist column to be hidden i.e. A

2) Press and hold down the CTRL key

3) While holding the CTRL key, left click on the rest of the columns you want to hide i.e. C and E

4) Right click and choose Hide

View all Excel hints and tips


Server loaded in 0.07 secs.