Freeze Panes/Columns or Floating Cell Group?

ArPharazon

Board Regular
Joined
May 3, 2004
Messages
51
Office Version
  1. 2016
  2. 2013
  3. 2007
Platform
  1. Windows
I have a running personal budget spreadsheet set up. It's very basic and uses Sum to keep a running $ total. (None of the templates I found were any use).

What I want to do is have my credit cards info in a group of cells to the right that moves down as I get further along in the running budget.

I've tried Split and Freezing Panes and Watch Window. None of these worked.

Doing it as an image won't work because I'd like to be able to edit the credit card balances as I go.

In the attached example, the group of cells highlighted in yellow would be the ones I'd like to freeze or float as I scroll down.

Any ideas?

Excel Floating Cells 2021-09-14_14-35-54.jpg
 

Excel Facts

Can you AutoAverage in Excel?
There is a drop-down next to the AutoSum symbol. Open the drop-down to choose AVERAGE, COUNT, MAX, or MIN
Why freezing doesn't work? What do you mean?
You can put this group on top of the sheet and freeze the first four rows.
 
Upvote 0
Why freezing doesn't work? What do you mean?
You can put this group on top of the sheet and freeze the first four rows.

I did try that, but it also freezes the first four rows of the other columns to the left (which is why I tinkered with Split). I suppose I could move everything else down 4 rows.
 
Upvote 0
Another way to do it is to have a userform on top of the app window it is independent of the sheet and of the scrolling.
 
Upvote 0

Forum statistics

Threads
1,215,473
Messages
6,125,012
Members
449,204
Latest member
tungnmqn90

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top