Posted to microsoft.public.excel.worksheet.functions

shark1966

external usenet poster

Posts: 6

Pasting data with hidden columns

I have a spreadsheet with 40 columns - 20 hidden and 20 shown. All 40 columns
have formulas. I want to be able to quickly copy and paste the values from
the 20 shown columns into another worksheet. When I do it now, all columns,
including the hidden ones, paste. How can I get it so only the shown cells
paste?

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
macro	unouwanme	Excel Discussion (Misc queries)	9	August 31st 06 09:38 PM
MATCH UP DATA IN COLUMNS	jickes	Excel Worksheet Functions	2	March 2nd 06 01:14 AM
pasting data over hidden cells	KyWilde	Excel Worksheet Functions	3	May 23rd 05 01:35 PM
Sort pages?	David	Excel Discussion (Misc queries)	15	May 13th 05 11:33 PM
Pulling data from 1 sheet to another	Dave1155	Excel Worksheet Functions	1	January 12th 05 05:55 PM

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

About Us

"It's about Microsoft Excel"

Menu

About Us