Forum Home
Press F1
Thread ID: 100463	2009-06-09 02:31:00	Excel : Pasting content into a column with hidden cells	richfort (14985)	Press F1

Post ID	Timestamp	Content	User
780723	2009-06-09 02:31:00	I have 2 spreadsheets . One is a modified copy of the other . The copy has been trimmed down to contain none of the hidden rows in the original . No that I have to merge the two back together again I'm having difficulty in getting the rows to match up . When I paste in the updated column it recognises the hidden rows in the paste process and therefore I end up with the updated cells getting pasted into each row sequentially as opposed to how the cells appear visually . Does anyone know of a way to paste into a set of cells and have the paste function ignore the hidden cells in the destination file?	richfort (14985)
780724	2009-06-09 05:38:00	Done similar a few years back. Right click the toolbar - select customize - then commands tab - choose edit in categories. Then scroll down on R/H side to "select visible cells", then click and drag it to the toolbar. Then try it during your selection/paste process...	kahawai chaser (3545)
1