Not pasting in hidden cells?

Ste_Moore01

Active Member
Joined
Jul 13, 2005
Messages
467
Hi guys,

I have a sheet where there are hidden rows.
The example below shows my sheet but with the hidden rows highlighted in yellow.
ELECTRICAL PRICEPACK MAKER.xls
ABCDEFG
10STOCK REFERENCEPRICEDISC.PER (FOR TRUNKING TYPE NO. OF METRES)TOTALDISC. OFF TRADE
111G/DRY-4740100
121G/DRY-BLU1000100
131S/20200100
141S/20B  200100
151S/25200100
161S/25B  200100
172G/DRY-4740100
182G/DRY-BLU1000100
192S/20200100
202S/20B  200100
212S/25100100
222S/25B  100100
233S/20200100
243S/20B  200100
253S/25100100
DETAILS ENTRY


Sometimes I have had to change the formula in column F and I was wondering, rather than having to copy and paste it into each individual cell in the table, is there a way of highlighting the whole column and pasting it without changing the hidden/yellow rows?

It's not so much as an urgent problem as it is a query.

Any help would be much appreciated.

Thanks! :)
 

Excel Facts

Whats the difference between CONCAT and CONCATENATE?
The newer CONCAT function can reference a range of cells. =CONCATENATE(A1,A2,A3,A4,A5) becomes =CONCAT(A1:A5)
I'm sorry, I think I didn't make myself clear enough.

I'm hoping to copy the formula from F11 (for example) and paste it in all the cell in column F without pasting it in the yellow rows which are normally hidden. I was wondering if there was a way of doing this.

Also, I'm quite new to the macro code thing so I was hoping for a little more in-depth instructions as I'm thick as 2 short planks! :LOL:

Thanks for your help!
 
Upvote 0
Just so you know, this isn;t an urgent problem because I can always move the hidden rows to the bottom of the list and then if I copied the formula down it wouldn't affect it.

It was more a query than a problem.

Thanks anyway! :)
 
Upvote 0
Ste_Moore01

Try this:

1. Copy the formula
2. Select the whole column (or the part of it covering where the formulas have to be copied to)
3. Through the menus go Edit|Go To...|Special...|Visible Cells Only|OK
4. Paste
 
Upvote 0
Thank you very much, Peter!

That works perfectly!

I've even made myself a macro so all I have to press now is Ctrl+N!

Thanks again! :)
 
Upvote 0

Forum statistics

Threads
1,216,105
Messages
6,128,859
Members
449,472
Latest member
ebc9

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