1. Ctrl + Z (x2) keyboard shortcut for undo, 2. Put the results one column over and then delete the column inbetween, 3. Select "Undo Calculated Column" and then resize the table.
---------------------------------------------------------------------------------
#exceltips #exceltutorials
SUBSCRIBE: [ Ссылка ]
Microsoft Office 365, 2016, Office Insider, Version 2011
How to stop a table automatically expanding in excel
Теги
stop table expandstop table expandingstop table automatically expandingstop autoexpansionstop auto expansionundo table auto expansionprevent a table expanding in excelput results next to a tablevalues next to a tablemicrosoft exceldynamic arrays next to a tablestop table expanding in excelexcel stop table auto expansionstop a table expanding in excelundo table expansion in excelundo table auto expansion in excelstop table auto expanding in excel