Free Excel Tutorial for Engineers : Editing Excel Sheet

As mentioned earlier this chapter deals with other formatting and editing options that are very useful in creating a spreadsheet.

Editing

Copy, Paste & Paste Special:

These are some of the most basic options in excel that allows you to duplicate content in one cell in other cells or other worksheets.

121.png

122.png

123.png

Text to Column:

This option allows you to convert bulk text from one column to different columns.

124.png

Navigation:

This sub section provides you with some simple shortcuts to navigate within the worksheet to easily access particular cells in the worksheet.

125.png

Find & Replace:

This option allows you to identify specific data from huge worksheets and replace only required data with other values.

126.png

Auto-Fill:

This speeds up your data entry by enabling automatically filling data in different cells, such as series, dates, etc.

129.png

Hide & Unhide:

This option allows you to hide particular rows or columns in a worksheet that are not in use while you are working on data.

130.png


131.png

View Options:

This option allows you to view different excel sheets to refer and compare while working on different worksheets.

132.png


133.png


134.png

Sort:

This option allows you to put your data in a proper order, such as alphabetically or in ascending or descending order.

135.png

Filter:

This option allows you to find only the relevant data that you require to work on at a time, such as account entries made on a particular date, or purchase dates of the same product in different months.

136.png

Shortcuts:

This sub section provides you with some simple keyboard shortcuts for all the editing and navigating options described above.