As mentioned earlier this chapter deals with other formatting and editing options that are very useful in creating a spreadsheet.
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.
This option allows you to convert bulk text from one column to different columns.
This sub section provides you with some simple shortcuts to navigate within the worksheet to easily access particular cells in the worksheet.
This option allows you to identify specific data from huge worksheets and replace only required data with other values.
This speeds up your data entry by enabling automatically filling data in different cells, such as series, dates, etc.
This option allows you to hide particular rows or columns in a worksheet that are not in use while you are working on data.
This option allows you to view different excel sheets to refer and compare while working on different worksheets.
This option allows you to put your data in a proper order, such as alphabetically or in ascending or descending order.
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.
This sub section provides you with some simple keyboard shortcuts for all the editing and navigating options described above.