Spreadsheet Formatting

The spreadsheet menu is located under the Application Title Bar at the very top. The menu commands and the special option and input boxes that appear allow you control over the spreadsheet layout. GLS will give you the information, data, and sample layout. You supply the formatting. For example, if you want a worksheet that has all the players names and phone numbers. you run the League Roster Query. However, the query report also gives the players addresses. You simply select the columns which hold the address data and click on the Grid Menu...Click on Delete....Click on Columns. You will control how the report looks. You may find for example that you have to make a number of columns narrower in order for a printed report to fit on an 8.5 x 11 sheet. Or you may have to change the Printer Setup Mode to Landscape in order to have the look you want.

Once you get a spreadsheet formatted to your specifications, so that the report has the information you want and the printed document is right, you can save it and use it as a template for running the report each week with updated data. First open the template report. Click "Save As..." from the File Menu and Save the template as a new file with a unique name. You can paste cells or blocks of data into this new file without changing the formatting such as column widths and row heights, borders, fonts, etc. Most of the reports in GLS can be printed as is or with minor changes.

From the Edit Menu you can cut, copy, and paste text and data, just as you would in any spreadsheet program.

Copy and Paste Data:  You can copy and paste data from one cell or range of cells to another cell or range of cells on the same spreadsheet or to a different spreadsheet.  Select the cells you wish to copy and from the Edit menu click "Copy."  The data is now in the Windows clipboard.  Next, select the cell or cells you wish to copy the data to, then from the Edit menu click "Paste."  The data will be pasted to the new cell(s).  You can use the convenient keyboard shortcuts for copying (Ctrl - C) and pasting (Ctrl - V) data.  Only the data or text is copied and pasted using this method.  Also, it does not copy row height or column width.  Data and text ONLY.  Formats such as color, borders, font, etc., and cell types are not pasted.  The data and text take on the formats of the new area in which they are pasted.

Copy and Paste Formats and Cell Types:  You can copy formats and cell types from a cell or range of cells to another cell or range of cells. This functionality can be found on the Edit Menu... "Copy and Paste Cell Types, and Formats."  Or you can select the "Copy and Paste Data, Cell Types, and Formats" which copies and pastes data, text and all formats to the destination cell(s).  This is a limited function.   The copy and paste formats function is handled in one operation.  It cannot be used to copy data and formats from one spreadsheet to another.  Also, it does not copy row height or column width.  This function operates a little differently than the standard copy and paste data function.  The data and formats in the destination cells will be pasted over by the copy data.  First, select the cell or the entire range of cells to copy, then while holding down the Control (Ctrl) Key, select the upper/left single cell where you want the cell or range pasted. In other words, you must select the cell(s) to be copied AND a single destination cell for pasting.

Copy and Set Row Height and Column Width:  You can also copy the row height or the column width of a cell or range of cells from one location on a spreadsheet to another location on the same spreadsheet.  Example:  If you want to copy the row height of rows 2 through 6 to rows 18 to 22.  Then select the range of cells in rows 2 through 6.  From the Edit menu click "Copy Row Height."  Next, select the first row where you want the row heights set, or row 18.  From the Edit menu click "Paste Row Height."  The rows will be set to the new heights.  The same works for Column Width.

GLS spreadsheets also support drag-n-drop operations. Select a cell or group of cells. Move the Mouse cursor to the edge of the selection until it changes from a cross to an arrow. Hold down the left Mouse button while you drag the cell or block to a new location. The cell or block will follow until you drop it by letting up on the left button. If you hold down the Control Key, "Ctrl Key" while performing drag and drop, instead of moving the cell or block you will copy the cell or block. You will then have two cells or blocks with identical contents and formats.

GLS spreadsheets also support Keyboard shortcuts for cutting (ctrl-x), copying (ctrl-c), and pasting (ctrl-v).