Create a chart:, Select your data (including headings) / Insert → Chart (usually Column or Bar) / Add a title (click the chart title and type a clear one)., Sort by A-Z/smallest to largest:, Click and drag along cells you want to sort / Right click -> Sort A to Z / Right click -> Smallest to Largest, Filter (show only some rows), Right click in your table / Click → Filter / Click the little drop-down arrow in a heading/ Tick/untick what you want to show., Enter and edit data neatly, Click a cell and type (letters or numbers) / Press Enter to go down a cell / Press Tab to go across a cell / Use Undo (Ctrl+Z) and Redo (Ctrl+Y)., Make text bold/Adjust column width/Add borders, Select heading cells → Bold (B) / Double-click the line between column letters (A|B|C) to auto-fit / Select the area → Home → Borders (choose “All Borders”)., Add up two cells, Click an empty cell next to the numbers you want to add / Type: =SUM(cell number and letter + cell number and letter) / Press Enter., Subtract two cells, Click an empty cell next to the numbers you want to subtract / Type: =SUM(cell number and letter - cell number and letter) / Press Enter., Times/Divide two cells, Click an empty cell next to the numbers you want to … TIMES: =SUM(cell number and letter*cell number and letter) / DIVIDE: =SUM(cell number and letter/cell number and letter) / Press Enter., Use AutoFill (copy a cell downwards), Click the cell with the text you want to copy / Find the tiny square on the bottom-right corner of the cell / Drag down to copy the text..

Excel match up

โดย
สั่งพิมพ์
ฝัง

ลีดเดอร์บอร์ด

สไตล์ภาพ

ตัวเลือก

สลับแม่แบบ

)
คืนค่าการบันทึกอัตโนมัติ: ใช่ไหม