Re: Can't resize Excel spreadsheet in response to Charles Swigart. There is an easier solution than changing screen resolution: mouse over the top of the title bar of the document until the vertical arrow shows up and then you can drag down the top of the document, shrinking it from the top.
What’s the difference between a table and a range of columns and rows on an Excel spreadsheet? How do I create and populate tables? And, once a table is created, how do we custom filter, format, and design those tables so they look professional in a report? We’ll show you how it's done.
What’s the difference between a table and a range in an Excel spreadsheet?There’s not much difference regarding the data. Both use columns (the database fields) and rows (the database records), and both can be sorted, filtered, calculated, custom formatted, and printed.Tables, however, have many additional benefits that regular spreadsheets lack.
The biggest plus is the option to use data from multiple tables to create queries and reports. Use this spreadsheet to practice creating, filtering, and formatting tables in Excel.
JD SartainFor deeper dives, check out my earlier articles on. How to create an Excel table1. First, enter the field names in the columns across the top, and then enter some records/data in the rows under each column. You could also open a workbook that’s already created and populated with data, or download the spreadsheet table we provided above.2. Next, place your cursor anywhere inside the range you want to convert to a table.3.
Select INSERT Table.4. The Create Table dialog opens with the table range pre-selected. If this is wrong, enter (or point) to the correct range; however, if correct, check the box that says My Table Has Headers, then click OK.5.
Excel converts the range into a beautiful color table with dark blue column headers and alternating shades of blue on every other row for an easy “at a glance” view of your data. JD Sartain / IDG WorldwideCreate an Excel table in two secondsIn addition, notice that the filter feature is automatically applied, so sorting by a specific field is accomplished by a few clicks of the mouse.6. For example, if you want to see which ski resorts get the most snow, click the down arrow beside the column/field called Average Annual Snowfall (inches). Select Sort Largest to Smallest, and it’s done.
You don’t even have to click OK.Notice that Grand Targhee Ski Resort in Targhee, Wyoming tops the list with an annual snowfall of 500 inches. (And I can attest to that, because I have skied there many times. It also has the best powder skiing in the world.) JD Sartain / IDG WorldwideUse the Filter to sort + query the table for specific informationMultiple sorts are also easy. What if you want to know which ski resorts in Colorado have the most skiable terrain? Or the most vertical feet?7. Click the down arrow beside State field.
Uncheck Select All, then check Colorado, and click OK.Notice that Excel shrinks the table so only the Colorado ski resorts are visible. Not to worry, the other ski resorts are still there. Once you change the State field back to Select All, the other ski resorts reappear.8. Next, click the down arrow beside the field called Skiable Terrain. Select Largest to Smallest and it instantly sorts placing Vail at the top with 5,289 acres.9.
Now click the down arrow beside the field called Vertical Feet/Drop. Select Largest to Smallest again and it instantly sorts placing Telluride at the top with 4,425 feet. JD Sartain / IDG WorldwideSort by State, then sort by Skiable Terrain + Vertical Feet10. Next, let’s add another field called Snowboards Welcome. Move your cursor to the blank column (L) at the far-right side of your table. Type the name of the new column in row 3 and notice that Excel adds the filtering and style format automatically.11.
It’s also easy to add new records. Just move your cursor to the bottom of your table and enter a new record on the next available row; for example, enter Snowbird on row 17 and Alta on row 18. Excel formats the style as you type.NOTE: You can also add/insert or delete columns and rows using the HOME tab, Cells group, Insert or Delete buttons. JD Sartain / IDG WorldwideEasily add new columns & rows How to custom-design tables to look professional in a reportYou can easily change the colors and style of your table with just a few mouse clicks.1. Move your cursor anywhere inside your table.2. Select HOME Styles Styles Table and choose a style design from the large drop-down graphical list.3. You can select New Table Style from the same drop-down list and customize your table design using the features provided in the New Table Style dialog window.4.
You can also customize the individual cells. Just select HOME Styles Cell Styles and choose an individual cell design from the large drop-down graphical list.
JD Sartain / IDG WorldwideSelect a custom style format for your new table.
.Click the table.Do one of the following:.Resize a row or column: Move the pointer below the row number or to the right of the column letter until you see, then drag to resize.Resize multiple rows or columns:, then move the pointer below the bottommost row number or to the right of the rightmost column letter until you see, then drag to resize. They’re resized proportionally.Resize all rows or columns in a table: Click in the top-left corner of the table, then drag the white square at the bottom edge of the table to resize rows; drag the square on the right edge of the table to resize columns; or drag the square in the bottom-right corner to resize both.As you drag, yellow alignment guides may appear when a table’s rows or columns align with rows or columns in another table on the canvas.
Comments are closed.
|
AuthorWrite something about yourself. No need to be fancy, just an overview. Archives
January 2023
Categories |