That way, your recipient could at least take a look at the calculation process.
But: In many cases it would be professional (and nice) to also send at least parts of your Excel file. That could be the case if somebody wants to check your results on an iPad or a similar device.
Also, it’s quite save to say that how a PDF file looks on your computer, it will most probably look like this on most other computers.Īnd that’s it for the advantages.
PDF stands for portable document format and has the reputation of not easily being manipulated.
2003, at least without any further conversion of Excel extension/ add-in).Īs you’ve probably heard of PDF files, we won’t go much into detail here.
Knowing these quick facts, there are the following advantages and disadvantages for the XLSX file format: Advantages It uses the open XML standard so which is documented well. Most of the time you use the XLSX format: It’s save (can’t store malicious code), has the maximum number of rows and columns and is best known. XLSX is available since Excel 2007 and replaces the old XLS file type. Cannot store Microsoft Visual Basic for Applications (VBA) macro code. The default XML-based file format for Excel 2007-2013. Microsoft says in the Excel help text about the XLSX file format: The large majority of Excel workbooks uses this format these days. The merge cells function only combines the selected cells into one without changing the alignment.The “default” file extension is XLSX. Merge cells Shortcut (keep default alignment) It is a time-saving feature if you want to join multiple groups at the same time. You can select groups of rows, but Excel will process each group separately. Select the range of cells: First, from cell C4 to E4, then F4 to H4, finally, I4 to K4. Shortcut to Merge cells Across is Alt, H, M, AĪre you want to merge cells across using multiple ranges? No problem!įor example, apply multiple selections using the Control key. After that, you will get a right-aligned text with combined cells. The Merge Across function joins cells across columns but not rows. This feature works only on the selected rows. This command will combine and center the cell content in Excel. Use the above-mention shortcut: Alt, H, M, C In the example, you want to merge and center the cells from C4 to E4. In this section, we will show you how these functions work using shortcut examples. You have four options under the ‘Merge and Center’ drop-down list. Finally, press C to select and apply the Merge and Center option. Next, press M to activate the Merge and center drop-down list.
After that, If you press the H key, Excel will highlight the Home Tab. Take a closer look at how the shortcut works: First, the Alt key activates the ribbon shortcuts.