app • Office Excel spreadsheet xlsx & csv - martindubenet/contents GitHub Wiki

Excel tips and tricks

Freeze lines

  • From the Excel ribbon menu navigate to :

    ➥[ View ]➥[ Window (group) ➥ Freeze Panes ]➥

    1. [ Freeze panes ] base on selection
    2. [ Freeze Top Row ]
    3. [ Freeze First Column ]

Transfer from *.csv to *.xlsx file

  1. Get the «Original.csv» file on your station.
  2. Create a new Excel file «NewExcelFile.xlsx», or a new tab within an existing file.
  3. From the Excel ribbon menu navigate to :

    ➥[ Data ]➥[ Get Data ]➥[ From file ]➥[ From Text-CSV ].

  4. Save.

Functions

  1. Addition + plus

    =SUM(B3:B6) for specific cells of a column.
    Or =SUM(B3:B) to addition all column's cells starting from the 3rd row (B3).

  2. Subtraction - minus

    =B1-B2-B3
    We can also use SUM within substrations like =B1-(B2+B3) or =B1-SUM(B2:B10).

My wikis

[ Content edition ][ Web dev & design ][ PHP ][ Wordpress ] md

MartinDube.net

⚠️ **GitHub.com Fallback** ⚠️