Paste shortcut?

W

wilbursdad

New Member
Joined
Dec 26, 2008
Messages
7
I have a locked group of cells at the top of my sheet. When scrolling on cells in the bottom of the sheet, I want to be able to click on a cell making it active and then the have the value in the next cell I click (on the top locked rows)sent to it. Now I repreatedly copy / paste for this. Does anyone know a shortcut? Thanks for your help in advance...
 

Excel Facts

Can a formula spear through sheets?
Use =SUM(January:December!E7) to sum E7 on all of the sheets from January through December
You must log in or register to reply here.

Similar threads

C
  • Solved
Selecting cells in a column quickly
Replies
1
Views
160
craigwojo
C
D
  • Question
Prevent paste from wepage overriding custom validation cell
Replies
0
Views
207
dpoag1
D
M
  • Question
Option Buttons in group get unselected in protected sheet
Replies
3
Views
181
MukulPurohit
M
N
  • Solved
VBA/Macro Help. Hopefully easy but I have NO idea what I am doing.
Replies
4
Views
279
ned lud
N
W
  • Question
Protected sheet disables macro buttons
Replies
5
Views
339
warda11
W

Forum statistics

Threads
1,215,022
Messages
6,122,716
Members
449,093
Latest member
Mnur

Share this page

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