Forum Discussion
Solved
excel in windows 10.
how to create a button that sorts by one column and then assigns an order in another column from one to 20.
- Hi, What do you mean by 'order from 1 to 20'? What is 1, what is 30? Kind regards Hans
[x] Like Tables
I do though stress, during classes, that when you work with column formulas you enter it...
...and in one step gets the formula, a new column and the column filled with that formula.
When undoing though, it demands three Ctrl+Z. One for each step.
The risk is when making a less visible change and typing Ctrl+Z, it is very easy to not have undone the change as expected. In the rest of the envirnment it is normally one change and one undo.
The only hint is a tiny green corner telling that the cell deviates.
I don't have any other suggestion for the interface - I'm confident that Microsoft have come up with the best solution among alternatives. Just notice that it is an area with a risk for unwanted results.
IMHO, that's always the risk to use the tool by the way it's not designed for. Structured table assumes same formula for entire column and keeps it as default formula for the column in background.
- Definately prefer structured tables 🙂
When it comes to calculated columns it may be a safer approach to simply delete the column and make a new one. Ctrl+Space and Ctrl+- (minus) and possibly Ctrl++ comes handy.