Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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? |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Pasting data with hidden columns
Select the range including hidden columns.
F5SpecialVisible cells onlyOK Now do the copy and paste. Gord Dibben MS Excel MVP On Thu, 2 Nov 2006 10:48:01 -0800, shark1966 wrote: 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? |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Pasting data with hidden columns
This worked! Thanks. When I used Paste Special - Values and Number Formates,
the data lost its formatting (column widths, font, bold text, etc.). Is there any way to keep that? "Gord Dibben" wrote: Select the range including hidden columns. F5SpecialVisible cells onlyOK Now do the copy and paste. Gord Dibben MS Excel MVP On Thu, 2 Nov 2006 10:48:01 -0800, shark1966 wrote: 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? |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Pasting data with hidden columns
After Special Pasting as you did, re-paste special and "Formats"
Gord Dibben MS Excel MVP On Thu, 2 Nov 2006 14:33:02 -0800, shark1966 wrote: This worked! Thanks. When I used Paste Special - Values and Number Formates, the data lost its formatting (column widths, font, bold text, etc.). Is there any way to keep that? "Gord Dibben" wrote: Select the range including hidden columns. F5SpecialVisible cells onlyOK Now do the copy and paste. Gord Dibben MS Excel MVP On Thu, 2 Nov 2006 10:48:01 -0800, shark1966 wrote: 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? |
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Pasting data with hidden columns
This worked. Thanks again!
"Gord Dibben" wrote: After Special Pasting as you did, re-paste special and "Formats" Gord Dibben MS Excel MVP On Thu, 2 Nov 2006 14:33:02 -0800, shark1966 wrote: This worked! Thanks. When I used Paste Special - Values and Number Formates, the data lost its formatting (column widths, font, bold text, etc.). Is there any way to keep that? "Gord Dibben" wrote: Select the range including hidden columns. F5SpecialVisible cells onlyOK Now do the copy and paste. Gord Dibben MS Excel MVP On Thu, 2 Nov 2006 10:48:01 -0800, shark1966 wrote: 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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
macro | Excel Discussion (Misc queries) | |||
MATCH UP DATA IN COLUMNS | Excel Worksheet Functions | |||
pasting data over hidden cells | Excel Worksheet Functions | |||
Sort pages? | Excel Discussion (Misc queries) | |||
Pulling data from 1 sheet to another | Excel Worksheet Functions |