Save as or export with values only

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hi all,
I have an xls sheet containing formula (sql.request). After running the
macros i get all the values in xls. how can save as this file to reflect only
the values keeeping the same format like borders colors etc.
thanks in advance.
Zubair
 
Hi Zubair,

Ctrl-A (Twice in xl2003) to select all cells
Edit | Copy
Edit | PasteSpecial | Values | OK | Esc
Click any cell .
 
Hi norman,
this way i get the values but i loose all my border wieght , colors etc.
i need to maintain the same format so that the look of the sheets doesnt
change.
remember i will copy the values in a blank xls sheet.
thanks
Zubair
 
Hi Zubair,

If you are copying to another sheet, do a second copy/pastespecial
operation, using the format option instead of the value option.

Alternatively, rather than copy/pastespecial ops

Right-click the sheet tab | "Move or Copy" | Select the "Create Copy"
option
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Making an ouput file 1
Code does as instructed, but creates and saves a Book1 2
Save all sheets in a new workbook 7
linking 9 workbooks 1
Saving File Format 2
error with countif formula on when adding linked spreadsheets 0
Save file with todays date ref#11235 2
Indexing Sheets in Referenced Workbook within formula 1

Back
Top