Forum Discussion
how to add colors without using the template for tables
mathetes hello, when i tried using tables, it told me that it would change the data in the top cells and it took me a looooong time to place all the bills into the tabs. Like I said, Im new to this so I dont know a lot about the short cuts but if i click that button and it takes away my information, i am going to scream!! Excel is NOT my friend but i am trying to become acquainted lol. I appreciate your assistance and I am going to try your tip right now
Luscious1 (That's quite a user name you've chosen)
OK. Shouldn't need to scream here, but yes, Excel could be compared to a large chain saw that can work a lot of havoc in an instant used by a novice.
Take a deep breath. There are ways to approach it--and, to put it all in perspective, Excel never itself causes the spilling of blood. Never. It can undo a lot of work, so here right off the bat are two ways at least to minimize that likelihood.
- Acquaint yourself with the "Undo" button, already mentioned by PeterBartholomew1 . It's the little left-pointing arrow with a tail, up top on the green tool bar at the very top of the Excel window. Or available as a menu selection under the main Edit menu
- Make a copy of your file BEFORE doing anything you're worried about. Back to the main menu again, use File....Save As or Save a Copy. That way, IF a disaster should happen, you'd have a back-up copy and could just carry on.
Whew!
OK, now to your worry. Creating your data set as a table--I assume you're talking of doing it through the Insert tool bar, where you just click on the "Table" icon--is NOT going to delete your data at all. It will set your rows to alternating colors and highlight the header row but lo and behold, leave the text and number entries as they were. And believe me, as you move on and learn the power of Tables, you're going to be grateful that you set it up that way.
Here is a link that you can study quickly so that you can approach the task with more confidence.
https://exceljet.net/excel-tables
There are also a number of YouTube videos--just search for "Excel Tables" to find them.