Posted to microsoft.public.excel.misc

Huber57

Posts: n/a

Pasting over hidden columns

I have hidden some rows in my workbook. I would like to paste some data
over these hidden cells and allow the data to skip them.

For example, if I have hidden Columns B and C and I paste 1, 2, 3, 4 (all
from different cells) into a row, 1 should appear in A1, 2 should appear in
D1, 3 should appear in E1, etc. Do you know how I can skip hidden rows when
I paste data?

I am using Excel 2003.

Sincerely,

huber 57

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

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

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
HIDDEN COLUMNS	acp20770	Excel Discussion (Misc queries)	1	December 28th 05 06:46 AM
HIDDEN COLUMNS	Jolo	Excel Discussion (Misc queries)	0	December 27th 05 07:19 PM
Pasting on Filtered Data Sheets without pasting onto hidden cells	CCSMCA	Excel Discussion (Misc queries)	1	August 28th 05 01:22 PM
excel macros truncating tabs for hidden columns.	SharanS	Excel Discussion (Misc queries)	0	February 17th 05 05:05 AM
How can I see column headings of hidden columns in Excel before u.	Beachcomber	Excel Discussion (Misc queries)	10	December 10th 04 01:35 PM

All times are GMT +1. The time now is 12:25 AM.

About Us

"It's about Microsoft Excel"

Menu

About Us