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


Reply
 
Thread Tools Search this Thread Display Modes
 
Old 02-16-2019, 07:00 AM   #1
In Runtime
 
Join Date: Aug 2014
Location: UK
Posts: 332
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, 08:08 AM   #2
Fully Optimized
 
strollin's Avatar
 
Join Date: Mar 2011
Location: USA
Posts: 2,241
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, 11:30 AM   #3
Fully Optimized
 
AMD_man's Avatar
 
Join Date: Dec 2016
Location: Argentina
Posts: 1,625
Default Re: Help with Excel please

What exactly did you try? According to this that's not possible.
__________________
"I so enjoy watching history warp as words pass
from the lips of one to the ears of another.
Imperfectly formed, half understood, poorly remembered."
AMD_man is offline   Reply With Quote
Old 02-23-2019, 04:00 PM   #4
Site Team
 
root's Avatar
 
Join Date: Mar 2004
Posts: 8,072
Default Re: Help with Excel please

As said in that link you need to freeze columns:
https://www.excel-easy.com/examples/freeze-panes.html
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
Reply

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 09:50 PM.


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