Hi,
I have a Excel spreadsheet with data already on it, but how can I make all the letters (after I type enter) to automatically make a row and columns UPPERCASE without using the CAPS LOCK key? I want everything in uppercase letters. So for instance, if I type in lower-case, I want it to automatically change to uppercase after I hit enter or tab in each cell.
Also, I have a drop-down menu bar in a cell and how can I clear all the contents from it.
I dont use the drop-down menu, instead, I enter the data manually and finds the rest of data tha way also. But it still fills up. How can I clear items from the drop-down menu?
Thx.
Bookmarks