Excel pasting - how to paste blank columns without overwriting formula

  • Thread starter Thread starter Leonell
  • Start date Start date
L

Leonell

I have an output file from Access where I have created an Excel shee
which has blank columns in it. I want to paste the entire content
into a template which has corresponding formula where the blank column
are. I have tried Paste Special, Value, and ticking Skip Blank
thinking that the blank columns would be ignored and the formula left.
Unfortunately what seems to happen is the blank cell is written ove
the formula and I lose the information.

I operate in Excel 97 and an example of what I mean is as follows: Th
/ are indicative of a new column.

Text Field / Text Field / Currency / Blank Field / Text Field.

I copy all, and then paste into a template which is as follows

Blank / Blank / Blank / Formula / Blank.

Is there a way to paste all columns in without overwriting an
underlying formula
 

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

Need Array Formula for Counting Blank & Non Blank Cells (Multiple Criteria) 1
Excel 2002: How to avoid pasting blanks ? 3
How to paste blanks only without overwrite exist cells in excel 1
Automatically Enter Formula in a Cell After Entering Data in Another Cell 0
Copy & Paste 2
Having Blank Cells, etc. ? 1
Paste Special as Values: no recognition of blanks 3
macro that will paste a number in first blank cell of a column 1

Back
Top