Im happy to hear you are learning more about Excel and enjoying the tips.I mentioned this tip (2) in my post on 17 Excel shortcuts for 2017, but thought I should explain it in more detail.CtrlEnter is a shortcut I use all the time when entering data or formulas.This is the default behavior in Excel, and it allows us to quickly work our way down a list when entering data into cells.
So, CtrlEnter keeps the selection on the active cell after entering data or a formula. In last weeks video I was entering the percentage completion number in the cell. I wanted to keep that cell selected so I could type a different number in it to see the change in the chart. I didnt want to have to hit Enter, then up arrow back to the cell. It might not seem like much, but think about how many times you have edited a cell and then wanted to make additional formatting changes or copy the cell. This will keep the active cell selected after pressing enter. You can still use the up and down arrow keys to select cells. This saves time from having to copypaste or fill down and across. However, if the cells that are NOT in the same row or column, then CtrlEnter can be a real time saver. The Go To Special menu helps us select all the cells of the same type. In the screen cast below I have a report with region names in column A. The region names need to be filled down to the blank cells below in each area. Then we can input a simple formula to reference the cell above, and press CtrlEnter to fill the formula to all blank cells. How do you use CtrlEnter Please leave a comment below with any suggestions, tips, or questions. Its challenging but very rewarding to have a new addition to the family. I should know as I have 4 daughters ranging between 35 years down to 13 years of age. Yes, you can copy a range of cells that contains formulas between spreadsheets. Enter Formula In Excel For Multiple Cells Plus CtrlEnter IsI just learned about Go To Special yesterday- that plus CtrlEnter is magic It saves a ton of time. Enter Formula In Excel For Multiple Cells How To Fill NonToday you taught me the RANDBETWEEN formula and how to fill non-contiguous range with data. Totally awesome- you have changed my work life the past few months.
0 Comments
Leave a Reply. |