|
|
|
1. Edit Genie shortcuts to avoid conflicts
|
|
Summary:
Learn how to edit Genie keyboard shortcuts if they conflict with other keyboard shortcuts on your computer
|
Keywords:
Genie, GenieNews, Genie News, keyboard shortcuts, Style box, Style apply dialog box, conflict
|
|
|
2. Copy to the same pattern
|
|
Summary:
Learn how to use Genie to copy cells to the same pattern.
|
Keywords:
Genie, GenieNews, Genie News, copy and paste to same pattern, copy, paste
|
|
|
3. Rapidly insert subtotals
|
|
Summary:
Reduce the time needed to insert subtotals from over a minute to one second.
|
Keywords:
Genie, GenieNews, Genie News, Genie shortcuts, Ctrl+Alt+=, ESP styles, SUBTOTAL, SUM, row height, Ctrl+Alt+9, keyboard shortcuts.
|
|
|
4. Copy selection sum moves calculations via Clipboard
|
|
Summary:
Learn to use Genie's Copy selection sum utility to quickly copy, to the Clipboard, the result of a calculation performed on a selection of cells. This enables easy pasting of formula results into other applications.
|
Keywords:
Genie, GenieNews, Genie News, copy, clipboard, SUM, AVERAGE, COUNT, COUNTA, MIN, MAX, applications
|
|
|
5. Rapidly insert standard borders for totals
|
|
Summary:
Reduce the time needed to add standardised borders from tens of seconds to only a few seconds.
|
Keywords:
Genie, GenieNews, Genie News, Genie shortcuts, Ctrl+Alt+-, ESP styles, SUBTOTAL, SUM, keyboard shortcuts.
|
|
|
6. Add the ESP column titles range
|
|
Summary:
The shaded titles area in ESP sheets has many benefits, which help the reader quickly locate information about the sheet and the columns of data.
In addition, the titles area includes the afbSheet name range (used for freezing and unfreezing panes), the ttSheet name range (used filtering and copying right), row and column print titles and formulas for organisation name and date/time stamping (referencing the Params sheet) and all the ESP Cell styles formats as well.
To apply an ESP titles area to a sheet that does not already have one, you only have to select a range and click a Genie button. Discover the button and what it includes into the sheet.
|
Keywords:
Genie, GenieNews, Genie News, Genie shortcuts, Genie styles, Genie sheets manager, afbSheet range name, ttSheet range name, Genie Utils (filter, copy right)
|
|
|
7. Customise your Menu sheet
|
|
Summary:
Learn how to customise an ESP-standard Menu worksheet for quick and convenient access to important components of your workbook.
|
Keywords:
Genie, GenieNews, Genie News, Navigate, Navigation, Menu, Menu sheet, Menu sheet modify dialog box, Contents, Index, ESP standard sheets
|
|
|
8. The Genie Menu shortcuts dialog box
|
|
Summary:
This article explains the functioning of the Genie Menu shortcuts dialog box.
|
Keywords:
Genie, GenieNews, Genie News, Genie menu shortcuts, Menu shortcuts
|
|
|
9. See two windows of a workbook at once
|
|
Summary:
It's often useful to be able to see two different sections of a worksheet simultaneously, such as totals and source data. This article explains how Genie can make this easy to achieve.
|
Keywords:
Genie, GenieNews, Genie News, Windows of workbook, two windows, same workbook
|
|