#1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 1
Default 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
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 1,231
Default 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.


Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On



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

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"