Microsoft spreadsheet cell data entry

Gateway / Mx6436
May 13, 2010 at 08:46:19
Specs: Microsoft Windows XP MCE SP3, 1.794 GHz / 1982 MB
How come when I copy and paste text into a spreadsheet cell using the Works spreadsheet/Office Excel programs, it spreads the information to more than just the one intended cell automatically?

How can I prevent this from happening?

See More: Microsoft spreadsheet cell data entry

May 14, 2010 at 12:26:43
Because sometimes Excel thinks it knows what's best for you.

Excel tries to help you by remembering the settings from the last time you used Data...Text to Columns.

Sometimes it will split the pasted data into columns because the last time you used that function you had it set for Delimited...Space.

You could try using ALT E S V.

Check out this list of pasting tips then scroll down to the bottom of the comments and read what Sam had to say on May 12, 2010.

Report •

May 14, 2010 at 16:03:15

If you are pasting data into single cells, you can select the cell and paste into the formula bar - then it stays in one cell.


Report •

May 16, 2010 at 19:09:32
Ya.... I tried selecting the cell and pasting into the formula bar at the top, but did not have luck so I went back to using OpenOffic Calc.

Pasting information into the formula bar works for that program.

Next time I load the programs that came with the laptop, I will refer to both tips, thanks guys.

Report •
Related Solutions

Ask Question