Go Back   Computer Forums > General Computing > Software and Operating Systems
Click Here to Login
Join Computer forums Today

Thread Tools Search this Thread Display Modes
Old 02-16-2019, 08:00 AM   #1
In Runtime
Join Date: Aug 2014
Location: UK
Posts: 373
Default Help with Excel please

I am using Microsoft Excel 2010 and I have quite a large spreadsheet that I use on a regular basis.

What I am looking to do is to make it so that the very last column on the spreadsheet is always visible down the right-hand edge of my monitor. As things are at the moment I have to scroll right across the speadsheet in order to see this last column.

I have had a look on-line but they seem to be referring to freezing either the header, the first row or the first column. I can't find anything that helps me to freeze the very last column.

Are there any Excel experts that could offer some guidance please.

Many thanks.

bluenose1940 is offline   Reply With Quote
Old 02-16-2019, 09:08 AM   #2
Fully Optimized
strollin's Avatar
Join Date: Mar 2011
Location: USA
Posts: 2,555
Default Re: Help with Excel please

If there are columns in the sheet that are necessary to be there but you don't need to have them visible, you could hide them in order to reduce the width of the sheet and possibly keep the last column visible.

strollin is offline   Reply With Quote
Old 02-16-2019, 12:30 PM   #3
Fully Optimized
AMD_man's Avatar
Join Date: Dec 2016
Location: Argentina
Posts: 1,656
Default Re: Help with Excel please

What exactly did you try? According to this that's not possible.
"Perception without comprehension is a dangerous combination."
AMD_man is offline   Reply With Quote
Old 02-23-2019, 05:00 PM   #4
Site Team
root's Avatar
Join Date: Mar 2004
Posts: 8,107
Default Re: Help with Excel please

As said in that link you need to freeze columns:
You can't freeze stuff on the right. I'd suggest you just insert a new column A and then just set that to display whatever cell you are trying to keep onscreen.
I didn’t fight my way to the top of the food chain to be a vegetarian…
Im sick of people saying 'dont waste paper'. If trees wanted to live, they'd all carry guns.
"The inherent vice of capitalism is the unequal sharing of blessings; The inherent vice of socialism is the equal sharing of miseries."
root is offline   Reply With Quote

Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are Off

All times are GMT -5. The time now is 05:10 AM.

Powered by vBulletin® Version 3.8.8 Beta 4
Copyright ©2000 - 2020, vBulletin Solutions, Inc.
Search Engine Friendly URLs by vBSEO 3.6.0