When you are editing a table and right-click on a cell, the context menu gives you additional options for Insert, including "Table Rows Above" and "Table Columns to the Left". If formulas are set up correctly, then formulas get copied into the newly inserted row.

I would like to see the following option available when you right-click on a row number WITHOUT using Excel Tables:

Insert > And Copy Formulas

Inserting would behave normally (including copying formatting), but in terms of cell contents, only formulas would be copied, not other text.

A few options are available via the paintbrush after inserting a row, such as "Format Same as Below" and "Format Same as Above" and "Clear Formatting", but there isn't an option for copying formulas. Sure, you can press Ctrl+d to copy everything from above, but it would be great to just copy formulas.

Desktop, Office 2016: volatile cells are recalculated before 'paste values' is executed. This leads to unexpected and unpredictable results; I'd like to propose that Excel turn off calculations while pasting values to avoid changing values

I use random values sometimes to generate sets of fake data, but I might re-generate it several times until I get a data pattern that matches the training lesson material (like a fairly normal curve, vs a binomial distribution of random values)

Deeper explanation: open a new sheet, and in any cell enter =rand(). Look at the value. Copy the cell, then paste value back into the same cell. The resulting value is not the original copied value, presumably because the value is recalced in memory before the paste value action is executed

The little green triangles really make some worksheets look unattractive. I have worksheets where the cells contain formulae but are not protected because I WANT the user to be able to change them. I can get rid of the green triangles on a case by case basis, but when the user changes the formula, they come back. I don;t want to turn error checking off at the Application level.

There should be the option to turn each of the classes of error checking on or off at least at the Workbook level or better at Worksheet level.

And, yes I know I can do it in VBA but that can only be done at the cell by cell level (not even by selected range) and so is slow and cumbersome.

What about if we make a Routine call (ALT_S for switch or swap) to switch two cells or two rows or two equal range for each other
normally we copy the first cell or row to a place(say third place) and cut the sound cell or row and past it to the first cell or row and then cut the third place to sound place
3 or 4 steps
1- If I point to a row and press ALT_S the excel know that I want to switch the row with anther row
2- if I point to anther row and press ALT_S again the excel will switch the first row with this row
2 step only

"To find a Special Character" For example in excel file i have around 50k data. in few cells some special characters are included like "250#, 560^, 648*". need to remove this special characters. i will remove by using find and replace option. if we know the special characters we can use these option. if we don't know what are the special characters are added. i think we have check manually and have to remove. is there any function or formulas to find special characters in excel if not. if excel team added this features it will be better to user to find the special characters. Sample file attached with this for reference. Thanks.