merged cells excel

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

Forum home » Delegate support and help forum » Microsoft Excel Training and help » Merged cells in excel

Merged cells in excel

resolvedResolved · Low Priority · Version 2007

Pamela has attended:
Excel Intermediate course

Merged cells in excel

If the headers of a sheet are mered over 2 cells how do you get the freeze frames function to work?

RE: Merged cells in excel

Hi Pamela

Thanks for getting in touch.

The freeze panes feature should work fine with merged cells. Just put the cursor below and to the right of what you want to freeze.

What's the issue you're having?

Kind regards

Gary Fenn
Microsoft Office Specialist Trainer

Tel: 0207 987 3777
Best STL - https://www.stl-training.co.uk
98%+ recommend us

London's leader with UK wide delivery in Microsoft Office training and management training to global brands, FTSE 100, SME's and the public sector

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:

Cycling through Absoulte cell references

If you are working with formulas in excel and need to convert your formula to an absolute formula, instead on manually adding in the $dollar signs you can highlight the specific part of your formula and press the F4 key.

You can cycle through all the absolute options by pressing the button (up to four times)

View all Excel hints and tips


Server loaded in 0.08 secs.