Wednesday, November 29, 2017

Excel Automatically number rows so cut and paste works

=Row()-number

number = number of rows down the list.
Then you can cut and paste and it will keep the correct numbers.

In the example Row()=3; number = 2; 3-2=1

Tuesday, November 21, 2017

AutoCAD Save all system variables to a text file

Express tools...

Express > Tools > System Variable editor

Friday, November 3, 2017

Dialog box not showing up Move Dialog box No Spec Record found because User cancel

Dialog box was hidden on a screen that was disconnected.

Moved the dialog box to the main screen

To move a dialog using just the keyboard:
1. Hold down the ALT key.
2. Press SPACEBAR.
3. Press M (Move).
4. Let go of keys
5. A 4-headed arrow will appear. When it does, use your arrow keys to move the outline of the window.
5. When you are happy with its position, press ENTER.