EstimatorVJ SHORTCUT KEYS IN KEY ORDER


KEY

What this key achieves

CTRL+

The following functions are activated using the CTRL+key combination

- or Del

Delete current row

-›

Activate the Right Panel

‹-

Activate the Left Panel

Down Arrow

Edit existing OR Create new workup sheet

Down Arrow
(When in RC List Panel)
 Show Popup Menu for editing,RC Usage,and/or Duplicating the selected Resource

+ or Ins

Insert new row in front of current row

=

Display the SUM of the selected rows in the first selected column

A

Select All

B

Bold contents of cell OR toggle bold start/end (<b>/</b>) during editing

C

Copy

E

Centre justify selected cell contents

F

Find/Replace

G

Goto line number

I

Italicize contents of cell OR toggle italics start/end (<i>/</i>) during editing

L

Left justify selected cell contents

R

Right justify selected cell contents

U

Underline contents of cell OR toggle underline start/end (<u>/</u>) during editing

Up Arrow

Activate Parent Worksheet

V

Paste (from internal VJ clipboard)

X

Cut

Z

Undo

(

 NOTE: Only active during entry/editing of cell contents.
Adds a pair of brackets () at the current selected position. If text has previously been selected, then 'bookends' the selected text with the '(' and ')' brackets.




{

 NOTE: Only active during entry/editing of cell contents.
Activates a popup menu of Project and Worksheet Variables:
                                       



ALT+

The following functions are activated using the ALT key combination
Down Arrow Convert to lower case all text in selected cells
Up Arrow Convert to UPPER case all text in selected cells
FK11 Copy into each cell on this row, the previous non-blank cell in the same column


CTRL+ALT+

The following functions are activated using the CTRL+ALT key combination

-

Remove the current column

-›

 Move to next created EWS (while in ESTIMATE worksheet)
 Move to next created Vetting Sheet (while in a Vetting worksheet)

-›

Expand the Left Panel (while in RATE/COST worksheet)

‹-

Move to previously created EWS (while in ESTIMATE worksheet)
Move to previously created Vetting Sheet (while in a Vetting worksheet)

‹-

Collapse the Left Panel (while in RATE/COST worksheet)

A or +

Add a new column by duplicating the current column

=

Edit the Current column's formula

D or - Delete current column

E

Activate 'External' library in the RC List panel

F

 Find/Replace using text in currently selected cell for 'Find'

H

Hide the current column

L

Activate 'Local' library in the RC List panel

P

Toggle Preview Window between Open and Close

R

Rename the current column

U Unhide all columns and Reset them to their default postions

V

Paste (from external SYSTEM clipboard)

Down Arrow Edit existing resource/composite while in a Worksheet


SHIFT+CTRL+

The following functions are activated using the SHIFT+CTRL key combination
Up Arrow Move selected rows up 1 row
Down Arrow Move selected rows down 1 row


Function Key

The following functions are activated by pressing the Function Key #
FK11 Copy into this cell, the previous non-blank cell in the same column
FK1 Activate the 'edit popup menu' for the currently selected cell

ALT+Function Key

The following functions are activated by pressing the Function Key # while holding down the ALT key
FK11 Copy into each cell on this row, the previous non-blank cell in the same column
Miscellaneous

The following are Miscellaneous functions as described

SHFT+ALT+S

 Copy the currently selected cell contents into all rows of the same column in child worksheets for that row
ALT+Double Click Enter a calculation using referenced Variables

 





EstimatorVJ SHORTCUT KEYS IN FUNCTION ORDER



How do I achieve this?

KEY

The following functions are achieved by pressing the CTRL and KEY at the same time

CTRL+

Activate Parent Worksheet

Up Arrow

Activate the Left Panel

‹-

Activate the Right Panel

-›
Activate EDIT popup menu FK1

Bold contents of cell OR toggle bold start/end (<b>/</b>) during editing

B

'Bookend' previously selected text with the '()' round brackets

(

Centre justify selected cell contents

E

Copy currently selected cell contents

C

Cut
currently selected cell contents

X

Delete current row

- or Del

Display the SUM of the selected rows in the first selected column

=

Edit existing OR Create new workup sheet

Down Arrow

Find/Replace

F

Insert new row in front of current row

+ or Ins

Insert pair of round brackets '()' 

(

Italicize contents of cell OR toggle italics start/end (<i>/</i>) during editing

I

Left justify selected cell contents

L
Paste (from internal VJ clipboard) V

Paste Special - Paste previously 'Copied' cell into every selected cell

V

Right justify selected cell contents

R

Select All

A

Underline contents of cell OR toggle underline start/end (<u>/</u>) during editing

U

Undo

Z

 

 

The following functions are activated using the CTRL+ALT key combination

CTRL+ALT+

Activate 'External' library in the RC List panel

E

Activate 'Local' library in the RC List panel

L

Add a new column by duplicating the current column

+

Collapse the Left Panel (while in a RATE/COST worksheet)

‹-

Display the EXTERNAL Library in the RC List panel

E

Display the LOCAL Library in the RC List panel

L

Edit the Current column's formula

=
Edit a Resource or Composite on-the-fly Down Arrow

Expand the Left Panel (while in a RATE/COST worksheet)

-›

Hide the current column (this moves the column to the very right and recues it's width to a minimum)

H

Move to next EWS (while in an Estimate Worksheet)

-›

Move to previous EWS (while in an Estimate Worksheet)

‹-
Option in an Options Panel
 Key in Red

Paste (from external SYSTEM clipboard)

V

Remove the current column

-

Rename the current column

R

Toggle Preview Window between Open and Close

P

The following functions are activated using the SHFT+ALT key combination

SHFT+ALT+
Copy the currently selected cell contents into all rows of the same column in child worksheets for that row Click
TAB in an Options Panel Key in Red