Format as Table: Let me explain about tables in MS-Excel, once you've entered information into your worksheet, you may want to format your data as a table. Just like regular formatting, tables can improve the look and feel of your workbook, and they'll also help you organize your content and make your data easier to use. Excel includes several tools and predefined table styles, allowing you to create tables quickly and easily. MS-Excel provides numerous predefined table styles that you can use to format a table. If the predefined table styles don't meet your needs, you can create and apply a custom table style. Although you can delete only custom table styles, you can remove any predefined table style so that it is no longer applied to a table. You can further adjust the table formatting by choosing Quick Styles options for table elements, such as Header and Total Rows, First and Last Columns, Banded Rows and Columns, as well as Auto Filtering. When you have a data range that is not formatted as a table, Excel will automatically convert it to a table when you select a table style. You can also change the format for an existing table by selecting a different format. How to Create a Pivot Table with dropdown buttons to selected columns and filter the students record in the data Worksheet into a conditional “Ex: in English =>50”? Select your records table => Select Home Menu => Click Format as Table Tool => Click a Table style that you like => Select My Table has Header check box => Click OK => Click on dropdown button on the English field => Select Number Filters => Click Greater Than or Equal To => Type “50” in the first blank box in English section => Click OK. For more understanding, look at the screenshot please: Insert: While you are working in Worksheet, may need to insert a new row or a column in between the data that you have already entered in, so, you can insert rows above a selected row and columns to the left of a selected column. Similarly, you can insert blank cells above or to the left of the active cell on a worksheet. Cell references automatically adjust to match the location of the shifted cells. How to insert a new row in between row number 9 and 10? Keep Cursor point in a cell in the row 10 => Select Home Menu => Click Insert Tool => Click Insert Sheet Rows. For more understanding, look at the screenshot please: Delete: Once you entered data into the Worksheet, may be needed to delete some of the specific columns or rows without deleting all the data and that’s so simple to do, if you follow up this tutorial will be guided you to do in easy ways. How to delete selected rows? Select the rows that you want to delete => Select Home Menu => Click Delete Tool => Click Delete Rows. For more understanding, look at the screenshot please:
0 Comments
|
Archives |