ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)
-   -   MS Excel (https://www.excelbanter.com/excel-worksheet-functions/147758-ms-excel.html)

Cords

MS Excel
 
Does anyone know how to turn off all these stupid warnings when working in
excel. For example when merging I get this constant pop up telling me if I
merge data will be over written....DA! Thanks

Harlan Grove[_2_]

MS Excel
 
"Cords" wrote...
Does anyone know how to turn off all these stupid warnings when working in
excel. For example when merging I get this constant pop up telling me if I
merge data will be over written....DA! Thanks


No way. Excel is a very nannying piece of software.

The particular warning you cite means Excel believes there's something in
cells other than the top-left one in the range you're trying to merge, and
that means there almost certainly is. If you want to avoid this particular
message, clear all cells other than the top-left one before merging.




All times are GMT +1. The time now is 04:53 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com