In code editor, Ctrl+R focuses the project explorer and then you can use arrow keys to go up or down
http://www.cpearson.com/excel/vbashortcutkeys.htm
Monday, May 22, 2017
Convert text to Numbers
1. use the =Value function
2. using the Paste Special, Multiply command. Enter the number 1 in a blank cell and then copy that value to the clipboard. Next, select the range of values stored as text, right-click, and choose Paste Special, Multiply, and then OK. You can then clear 1 from the worksheet cell.
3. select the range of cells that contain numbers stored as text, then choose Data, Text to Columns, and then click Finish. Don't select any choices within Text to Columns; simply launch the wizard and then click Finish
2. using the Paste Special, Multiply command. Enter the number 1 in a blank cell and then copy that value to the clipboard. Next, select the range of values stored as text, right-click, and choose Paste Special, Multiply, and then OK. You can then clear 1 from the worksheet cell.
3. select the range of cells that contain numbers stored as text, then choose Data, Text to Columns, and then click Finish. Don't select any choices within Text to Columns; simply launch the wizard and then click Finish
Saturday, May 20, 2017
Editing a formula
If you use Ctrl+Shift, pressing the arrow keys allows you to select "words" within the formula.
Spaces and line breaks in formulas
Normally you enter a formula without using any spaces. However you can use spaces and even line breaks within your formulas. Doing this has no affect on the formulas results, but may make the formula easier to read. To enter a line break in a formula press Alt+Enter
e.g.:
=SUM(January)+
SUM(February)+
SUM(March)
e.g.:
=SUM(January)+
SUM(February)+
SUM(March)
format of cell with formula
Format of cell with formula is same format as first referenced cell, unless that cell is formatted as a percentage, in which case it will be the format of the second referenced cell
Subscribe to:
Posts (Atom)