Create a New Workbook in Excel: Overview You can easily create a new workbook in Excel. A workbook is the default file type in Excel, much like a document is the default file type in Word. A workbook can contain multiple worksheets where the data is stored and manipulated in the columns and rows.
Freeze Panes in Excel: Overview You can freeze panes in Excel to view data in two separate sections of a long worksheet simultaneously. You can freeze panes in Excel to freeze one or two sections of a worksheet to prevent scrolling. Then you can then scroll the unfrozen section of the worksheet to view
Sort a Table in Excel: Overview You can sort a table in Excel using any of the fields available. Sorting is one of the main reasons that you create tables in Microsoft Excel. It allows you to easily organize information in the table records. By default, Excel can sort alphabetically or numerically in either
Format Trendlines in Excel Charts: Overview You can easily format trendlines in Excel charts if you applied them to one or more chart series. To format trendlines in Excel, click the “Format” tab within the “Chart Tools” contextual tab in the Ribbon. Then select a trendline to format from the “Chart Elements” drop-down in
Apply Password Protection to an Excel File: Overview When you apply password protection to an Excel file, you prevent people from opening it without knowing the required password. After password protection is enabled on a file, no one can open it without the password. Therefore, password-protecting files poses some risk. This is because if
Change the Chart Type in Excel: Overview After creating a chart, you can change the chart type in Excel. Alternatively, you can also choose a different sub-type of the same general chart type you first selected. Either way, note that if you change the chart type, you may lose custom formatting you have applied
Print a Chart in Excel: Overview To print a chart in Excel that appears embedded in a worksheet without printing the rest of the worksheet, select the chart or one of the chart’s elements, first. Alternatively, to print a chart in Excel that appears embedded in a worksheet along with its accompanying worksheet data, click into
Resize Columns and Rows in Excel: Overview There are many ways to resize columns and rows in Excel. You can adjust the width of columns to correct the display of longer cell entries. You can also adjust row height to accommodate larger fonts. To resize columns and rows in Excel, you must first select