• Skip to main content
  • Skip to secondary menu
  • Skip to primary sidebar

Mechanicaleng blog

siemens nx tutorial & injection molding technology

  • Plastic molding
  • Siemens nx
    • nx modeling
    • nx drafting
    • nx sketching
    • nx assembly
  • Mechanical basic
    • mechanical standard
    • Mechanism video
  • microsoft office
    • microsoft word
    • powerpoint
    • excel tips
  • About me
  • CONTACT ME
Home » microsoft office » excel tips » How to insert data in excel

How to insert data in excel

October 15, 2021 by mechanicaleng blog Leave a Comment

In this tutorial, I will guide to you how to insert data in excel? You can insert text, numeric value or formulas in excel. How many characters can we insert in excel? We can insert maximum  32000 characters into an excel cell.

Post contents

  • How to insert data in excel ?
    • Inserting formula.
    • Edit cell content

How to insert data in excel ?

For inserting data in Ms excel, double click to the cell where you want to insert data  and input what you want. Note, you have to set format text or number for this cell before imputing.

 

How to insert data in excel 2016

Some time, If your cell format is number and you want to input the number as “09123254”. The number “0” will hidden. How to show it? If you want to show it, you have to insert ‘ before it.

insert number in excel1

Inserting formula.

Go to cell where you want to insert formula, double click and enter the formula you want and press enter or navigation key. To insert formula, you have to input “=” before it.

insert formula in excel

For example, i will calculate sin(30)

Double click in the cell and typing, “=si” . Excel will guide to you the formula list. You can select sin comment from the list.

excel guide formula

Click the sin from the formula list, input “30)” and press enter to finish.

insert formula excel sin 30

Edit cell content

Go to cell where you want to edit, double click and enter the new data you want and press enter or navigation key

Related posts:

insert excel data to word by Inserting a whole Excel file 5How to insert excel data to word document how to copy data from excel to word 6how to copy data from excel to word without table Using CONCATENATE commandHow to add leading zeros in excel Random number from fixed set of optionsCreate random number in excel

Filed Under: excel tips Tagged With: excel beginner

Reader Interactions

Leave a Reply Cancel reply

Your email address will not be published. Required fields are marked *

Primary Sidebar

Recent Posts

  • what is spur gear | introduction
  • Mechanical engineering skills from training process
  • What is Inox | Stainless Steel?
  • How to create thread in nx
  • nx assembly| create a new part from the same part
  • how to calculate sum of squares in Excel
  • How to active GC toolkits in Siemens NX
  • How to create a sphere in nx
  • How to create a cone in nx
  • How to create a cylinder in nx

Copyright © 2023 · Magazine Pro on Genesis Framework · WordPress · Log in