To create an excel table, all you have to do is select a range of cells and press the table button from Insert ribbon in Excel (or use the shortcut CTRL+T). How to create table from a bunch of data? Excel will take care of everything thus making you a data guru. When you make a table (more on this in a sec) you can easily add more rows to it without worrying about updating formula references, formatting options, filter settings etc. Table is your way of telling excel, “look, all this data from A1 to E25 is related. Excel tables, (known as lists in Excel 2003) is a very powerful and super-cool feature that you must learn if your work involves handling tables of data. Excel table is a series of rows and columns with related data that is managed independently.
0 Comments
Leave a Reply. |
Details
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |