I want to hide columns and filter my worksheet, then save only the visible
cells. Is there a way to save a subset of a worksheet in this way
I want to hide columns and filter my worksheet, then save only the visible
cells. Is there a way to save a subset of a worksheet in this way
Create a new workbook.
Back to the original worksheet
Select all the cells (ctrl-a, twice in xl2003)
Edit|Goto special|Visible
Edit|Copy
back to the worksheet in the new workbook.
Edit|paste special|Values
edit|paste special|Formats
Save the new workbook.
If you need a macro, you can record one when you do it once manually.
quixoposto wrote:
>
> I want to hide columns and filter my worksheet, then save only the visible
> cells. Is there a way to save a subset of a worksheet in this way
--
Dave Peterson
Thanks, that did the trick
Julia
"Dave Peterson" wrote:
> Create a new workbook.
> Back to the original worksheet
> Select all the cells (ctrl-a, twice in xl2003)
> Edit|Goto special|Visible
> Edit|Copy
>
> back to the worksheet in the new workbook.
> Edit|paste special|Values
> edit|paste special|Formats
>
> Save the new workbook.
>
> If you need a macro, you can record one when you do it once manually.
>
>
> quixoposto wrote:
> >
> > I want to hide columns and filter my worksheet, then save only the visible
> > cells. Is there a way to save a subset of a worksheet in this way
>
> --
>
> Dave Peterson
>
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks