Tech Tips Home
The Best Tech Tips And Daily Deals
Newsletter On The Internet!

Shop online 24hrs a day or call us Mon-Fri
8:30AM-4:30PM EST - 1-800-915-2088
WorldStart Tech Tip And Store Search
Email: Password: Login Remember Me

Like what you see here? Subscribe to the Tech Tips newsletter!   Email: Subscribe

See Titles and Totals Simultaneously

Tuesday, June 24th, 2008 by | Filed Under: MS Excel, MS Office Help
 
Loading...


See Titles and Totals Simultaneously

If you frequently work with large amounts of data in MS Excel you may find yourself frustrated as you try to see both the column titles (at the top) and the column totals (at the bottom) at the same time.

You have probably tried to freeze the titles and then split the screen, thinking you could keep the totals in view in the bottom half of the split. But, of course, that didn’t do the trick, because any rows that are frozen are released as the worksheet is split on the screen. In other words, Excel just doesn’t seem to want to cooperate.

So, is there a way around those limitations to still get what you want?

Of course there is! In fact, there are a couple ways to do it.

Some of you may have decided that the best way to see both the column titles and totals simultaneously is to put the totals at the top with the titles. That way, when you freeze the rows, you include the total row too.

That certainly works, but if you’re like me, you just really like your totals at the bottom of the data column. So, what now?

Well, your solution can come in the form of a new window on the same file.

Yep, you read that correctly! Excel allows you to open multiple windows of the same file and each one can be set to display a different area of the worksheet.

With the workbook open, you’re looking for the Window menu, New Window choice. Or, for Excel 2007, you need the View ribbon, New Window button.

At this point, you have two windows open that contain the same workbook. To see them both, you need to arrange them properly.

For this step, you need the Window menu, Arrange choice (Arrange All button on the View ribbon in Excel 2007).

When the Arrange Windows dialogue box opens, choose Horizontal and then click OK.

Now, you have two views of the same workbook. You can also use each window’s border to resize as needed. For example, if all you want to see in the bottom window is the total row, you can scroll down to display the totals and make the window very narrow. You can then resize the top to fit the rest of the screen, maximizing your work space.

I should also mention that you can freeze rows in either window, allowing you to really have things your way. Titles and totals visible at all times, just the way you like it!

~ April

Comments are closed.

Like these tips? Get them for FREE in your email!

WorldStart's Tech Tips Newsletter

  • Tech Tips Daily - Become a tech pro! Get the very best tech and computer help sent directly to your email every weekday!

  • Tech Tips Weekly - If you don't want our Tech Tips newsletter every day, then sign up for this weekly newsletter to get the best information of the week. Sent on Fridays.

Other Newsletters

  • WorldStart's Daily Deals - Every week, we send out great deals in our Daily Deals newsletter. Many of these deals are exclusively for our Daily Deals newsletter subscribers and can't be found with our regular specials.

  • Just For Grins - Each issue includes a couple clean jokes, some funny quotes, and a hilarious reader's story. Newsletter is sent five days a week.


Enter Email Address:

Subscribe

Your e-mail address is safe with us!
We only use it to send you the newsletters you request. It is NEVER disclosed to a third party for any reason, ever! Plus, if you decided you don't like our newsletters (don't worry, you'll love them), unsubscribing is fast and easy.

Free Newsletter Signup



Tech Tips Daily

Become a tech pro! Get the very best tech and computer help sent directly to your email every weekday!

Tech Tips Weekly

The week's best in tech and computer help. Get your issue sent to your email every Friday!

WorldStart's Daily Deals

The very best deals on the Internet! Get a new set of incredible sales every day of the week!

Just For Grins

Clean jokes, funny quotes, and hilarious comics. Sent 5 times a week straight to your email.


Subscribe


Love Worldstart? Refer A Friend!

WorldStart's Premium Membership

Tip Archive


Categories:
Archives: