RELATE - from DMS Connect

Excel Tips & Tricks If you don’t use Microsoft Excel on a regular basis, it can be rather daunting. Here are a few tips for manipulating the layout, data and printing.

Column Width: To make each column wide enough to show all of the contents, press Ctrl+A to Select All, then double click a line between any two columns. The columns will automatically adjust so everything in them is visible. Removing Columns or Rows: To remove a column or row, click on the column letter or row number to select the entire column/row > right click > choose Delete. This will remove the column/row and move the others left or up. You can select multiple rows and columns too. Use the Ctrl key to choose columns/rows that aren’t adjacent. Adding Columns or Rows: To add a column or row, click on the column letter or row number to the right of (column) or below (row) where you want to insert your new column/row to select it. Right click > choose Insert.

Sort Data Alphabetically: To sort a column alphabetically, press Ctrl+A to Select All > click the Data tab in the top menu > click the Sort button (it says Sort under it) > select which column you want to sort by from the first drop down menu. If your column names don’t appear in the drop down menu, click the box next to “My data has headers” and they should appear. Click OK when done to sort the data. Print Preview: To see if everything will fit on a page before printing, choose File > Print. A preview will appear on the right of the screen to show you how the printout will look. Use the back arrow at the top of the window to go back to the data. You’ll now see a dashed line where the page will be cut-off. Adjust your data accordingly and try again. Fit on Page: To squish the contents of a document onto one page when printing, select the info you want to print > choose File > Print. Under the settings, instead of “Print Active Sheets” choose “Print Selection.” Then go to where it says “No Scaling” under the settings and pick “Fit Sheet on One Page”, “Fit Columns on One Page”, or “Fit Rows on One Page.” You can also adjust the margins as necessary to allow a bit more room for your print out.

Made with FlippingBook - Online catalogs