Whether you are already used to dealing with xls or handling this format for the first time, editing it should not seem like a challenge. Different formats may require specific applications to open and edit them properly. However, if you have to swiftly revise table in xls as a part of your typical process, it is best to find a document multitool that allows for all types of such operations without extra effort.
Try DocHub for streamlined editing of xls and also other file formats. Our platform offers straightforward document processing no matter how much or little prior experience you have. With all tools you have to work in any format, you won’t need to jump between editing windows when working with each of your papers. Effortlessly create, edit, annotate and share your documents to save time on minor editing tasks. You’ll just need to register a new DocHub account, and you can start your work instantly.
See an improvement in document processing efficiency with DocHub’s straightforward feature set. Edit any file quickly and easily, irrespective of its format. Enjoy all the benefits that come from our platform’s simplicity and convenience.
okay so first of all i have brought this data into excel from another file and you can see it hasnt quite been transferred across properly each line is split across three rows if i take the headings here and click and drag them they should be lined up like this however i cant just click and drag every single row because there are too many of them if i go down to the end of the table youll see i have over 2 000 rows so i need to find some other way of doing this first of all im going to do equals and then select this cell here and enter then i can drag this across to get all of the numbers in the top row and then i will do equals and move on to the next row and click and drag this across as well and then finally i can link to this cell here then ill move on to the next line and link to this cell here and drag this across and then link to this cell and drag that across as well and finally link to this cell now i will select these two lines and press ctrl h to open up the find and r