Select only filled cells in column to use insert command

**Nancy Dratwa** · 08-19-2013, 10:57 AM

I have a spreadsheet which contains data exported from another program. When it exports some of the lines are not lined up properly. I need to be able to select only the filled cells in the column to use the insert - right command. Can this be done?

**amy_d2** · 08-19-2013, 11:03 AM

Hi & welcome to the forum ,

in case column is filed with only data

select column press F5 -- special ---Constance --ensure (number , text, logical errors) are ticked

in case column is filed with formula

select column press F5 -- special ---formula --ensure (number , text, logical errors) are ticked

then you can use insert command

Select only filled cells in column to use insert command

LinkBack

Thread Tools

Rate This Thread

Display

Select only filled cells in column to use insert command

Re: Select only filled cells in column to use insert command

Thread Information

Users Browsing this Thread

Similar Threads

[SOLVED] Select only filled cells of a column and create a text file

[SOLVED] How to select all records in a empty column between to filled columns

Excel 2007 : Automatically insert a row when cells below are filled.

combo box select cells filled auto

[SOLVED] Select filled cells/rows in a spreadsheet

Bookmarks

Bookmarks

Posting Permissions