Public Schedule Face-to-Face & Online Instructor-Led Training - View dates & book

excel consultants - sorting data

Forum home » Delegate support and help forum » Microsoft Excel Training and help » excel consultants - Sorting the Data

excel consultants - Sorting the Data

ResolvedVersion Standard

Xiaojing has attended:
Excel Advanced course

Sorting the Data

How to delete the spaces between the datas? Show I use IF Then? Thanks

RE: Sorting the Data

Right click over the space the select delete and then shift cells up then this should move the rows up and remove the emplty space

Excel tip:

Selecting constant values only

If periodically you need to change all your values back to zero, but leave formulas, text and blank cells as they are select the entire worksheet, choose F5 function key, Special and then Constants and choose the appropriate sub-selections. To enter zero in all the selected cells type 0 and then press Ctrl+Enter.

View all Excel hints and tips

Connect with us:

0207 987 3777

Call for assistance

Request Callback

We will call you back

Server loaded in 0.12 secs.