FREE Excel Tips Newsletter from TheExcelAddict.com
Subscribe here to get more tips like this every week

The Excel Addict - Help with Excel 2013, 2010, 2007, 2003
March 17, 2016  
Greetings from The Excel Addict
Hi fellow Excel Addict,

It's such a beautiful, sunny, calm and 'relatively' warm day here today. Don't believe me? See for yourself. Click on my picture below.

In case you missed Tuesday's 'Excel in Seconds' newsletter, in it I described how to 'Show Pivot Table Data In Separate Columns". You can read it here.


Today I am going to show you how to "Tame the 'Unfrozen' Columns When Using Freeze Panes". I hope you find this tip helpful.

Please feel free to share my newsletter with anyone you think could use a little Excel help.


Take care and keep on Excelling,
Francis Hayes (The Excel Addict)
Email:  fhayes[AT]TheExcelAddict.com


Francis Hayes (TheExcelAddict.com)



If you missed my last newsletter, you can click here to view it online.
 

 
TheExcelAddict.com Quote of the Day

"Adopt the pace of nature: her secret is patience."
-- Ralph Waldo Emerson --

 
If you have a favourite quote, send it to me and I may post it in my newsletter.


Today's Microsoft Excel Tip

Taming the 'Unfrozen' Columns When Using Freeze Panes

When working with wide worksheets, you will sometimes need to work with data on the far right but also keep some of the columns on the left side of the sheet visible as well. You may already know that a good solution for this is Freeze Panes.

With Freeze Panes, you select the column immediately to the right of the ones you want to freeze. then from the View tab, click Freeze Panes, Freeze Panes. Now you can scroll to the right side of your worksheet and the frozen columns on the left remain visible.

In many situations, this works just fine. However, as you are working with the columns on the far right, if you are using the arrow keys to move around, you will sometimes scroll too far left and your data on the right scrolls out of view. Then you need to scroll back to the right again to access those columns. When this happens over and over it can be frustrating.

Temporarily Hide The Columns You Are Not Working On
A simple solution that I often use is to temporarily hide the columns that I'm not using. That is, hide all of the columns between the frozen columns on the left side and the columns I am working on on the right side. Now you can use your arrow keys to freely move between the frozen columns on the left and the unfrozen columns on the right.

Hide Columns To Scroll To Freeze Panes_in_Microsoft_Excel_2007_2010_2013_2016_365

Use Grouping to Temporarily Hide and Unhide Columns
Another trick that works great for worksheets where I regularly need to hide and unhide specific columns is to use Excel's Grouping feature. Grouping is normally used for hiding the details of subtotaled data but, in cases like this it also works well for quickly hiding and unhiding columns.

To hide column(s) using Grouping...

1) Select the headings for the columns (e.g. Columns E:BO) you want temporarily hide;

2) From the Data tab click Group. An outline bar and [-] symbol appears above the columns. When you click the [-] symbol, the columns will be hidden and the symbol changes to a [+];

3) To unhide the columns, click on the [+] symbol.

You now have a quick and easy way to hide and unhide these columns whenever you need to.

To remove this grouping feature, from the Data menu click Ungroup, Clear Outline.

DOWNLOAD PRACTICE FILE HERE

Temporarily Hide Columns Using Grouping _in_Microsoft_Excel_2007_2010_2013_2016_365


Thanks for supporting this newsletter and website

FREE Excel Tips Newsletter from TheExcelAddict.com
Subscribe here to get more tips like this every week

Disclosure: Some of the resources I recommend on my website and in my newsletter pay me a small referral commission if you purchase from them through links on my website or using my referral code. This helps offset the costs of my website. I've worked long and hard to build up my reputation online over the past 10 years as someone who provides exceptional value to my readers. So I'm not willing to risk that. As you know, I don’t just recommend anything. It has to be of outstanding quality and value. If you are EVER not completely satisfied with anything I recommend, please let me know and you will get your money...GUARANTEED. You can't lose.
"Spreadsheets Tips From An Excel Addict" is a weekly publication of TheExcelAddict.com.
Copyright Francis J. Hayes All Rights Reserved.

8 Lexington Place, Conception Bay South, Newfoundland, Canada, A1X 6A2 Phone: 709-834-4630