How to Use Zoho Sheet (Full Guide) Best Free Excel Alternative

Hey guys, welcome back again. Hope you

are doing well. I am MJ. In this video, I'll show you how to use Zoho sheet. So

from the basic I will try to show you step by step. So first thing is uh you need to sign in in Zoho because Zoho is a online tool. Okay. So you need to open any browser and then sign in. If you

don't know how to sign in, I have already upload the video about sign in.

Okay. When you sign in, uh you will get this screen here. uh just click on this app and here select the sheets. Okay.

And then simply click on new spreadsheet. So these are one of the

spreadsheet. So these are one of the best alternative for Excel. So it's look like Excel and it work as a Excel. Okay.

So here we got the same look or user interface as Excel. Almost same. Yeah.

Not exact same almost same. So let's try to type something here. Okay. I'm going

to type here and let's see whether the formula or other thing work or not. So I

am using the same method what I use for Excel to do the formula and look at that it's working perfectly. Okay. And I will use one more typical formula to add some

GST is equal to star 18% GST. Hit enter.

Look at that. It's working perfectly. So

all Excel formula almost all Excel formula work here. And let me type something here.

20 30. Okay.

And now I'm going to apply the same formula to all by pressing Ctrl D. And yeah,

it's working. Look at that. It's working

perfectly. I will sum. Yeah, look at that. The sum is done. Okay. So these

that. The sum is done. Okay. So these

are some basic stuff. And if you want to do some setting editing all this thing so you can go to the file. So first we will see how to do the page setup. Okay.

So go to file and go to here print and here select your current sheet. Okay. Or

you can select the entire workbook. So

I'm going to select the current sheet only and the paper A4. I will choose if you want you can go with the A3 legal letter all this thing. And I will take

the landscape and the scale I will keep default and margin. Yeah. If you want you can change the margin. Look at that.

Yeah. Okay. And after this just click on back. Okay. So this is how you can do

back. Okay. So this is how you can do the P setup. And after this give the file name to your sheet. I will give the

Zoho sheet or like this sheet. Okay.

And in the edit you have undo, redo, cut, copy, past, fill, uh cleaner, delete. Uh so you can delete the URL or

delete. Uh so you can delete the URL or row and in the insert you can insert the row and column like this. Look at that.

Yeah.

Yep.

And here is the chart. If you want to create the chart first select the data or value and go to the chart here and here select the chart like this and you

can do the editing here in the chart.

Yeah. Look at that. So it's very easy to use and the user interface is uh really very cool and easy. I really appreciate it. Okay.

it. Okay.

And next in the insert uh we have the images. If you want you can insert the

images. If you want you can insert the image and you can add the uh button, you can add the hyperlink. Here you can see the functions. So from here you can

the functions. So from here you can easily insert the functions.

It has a lot of feature. Yeah. And it's

free. And here define name you can add the nodes command checkbox. Yeah if you want to add the checkbox simply select your cell click on checkbox and it will

insert the checkbox. Look at that how easy it is. It's very simple. Yeah. And

you can show the values in the customization chart title format all these things. Yeah

these things. Yeah it has very nice user interface.

And then emojis. Yeah it has emojis also. Yeah. So you can insert emojis

also. Yeah. So you can insert emojis here. Looking nice. Yeah. Okay. And the

here. Looking nice. Yeah. Okay. And the

next in the format you can choose the uh theme format cell. Uh here is a shortcut key of inserting the date, currency and

number. And if you want you can change

number. And if you want you can change the table design. Uh font. You can

change the fonts, font size, bold, itallic, underline. It's easy things.

itallic, underline. It's easy things.

Okay. Uh here you can uh choose the your alignment. You can do the center, right,

alignment. You can do the center, right, left alignment and you can uh increase or decrease the indent. And these are wrap text. If you are going to insert

wrap text. If you are going to insert any picture here, then you can select the picture and do the wrap text. Okay.

So these are text rotation. If you are using the any uh text box, then you can easily rotate the text. Okay. And in the data you can sort, filter, group,

ungroup here a pure table, data validation and data cleaning uh text to column. You can convert the uh text to

column. You can convert the uh text to column easily. Yeah. And is a pattern

column easily. Yeah. And is a pattern field data collection sorry data connection uh link to spreadsheet. So if

you are using the uh many sheets then you can easily link the your one sheet to another sheet and data from picture.

Yeah. So you can easily uh import the text from the your image and this is a publish page. Okay. Uh in the review you

publish page. Okay. Uh in the review you can check the spell you can create the personal dictionary spreadsheet statics translate. Yeah it has a translate and

translate. Yeah it has a translate and audit edit history all this thing and in the tool we got the uh VBA micros. So

you can create the your own micros, you can write your own micros. And here is the custom function

and all these things. Yeah. And in the main bar uh we have the printer, undo or redo and these are format painter. And

here the font style, font size, bold, itallic. And you can fill the colors if

itallic. And you can fill the colors if you want. You can easily fill the

you want. You can easily fill the colors. And you can also give the fonts

colors. And you can also give the fonts or text to color. Okay. And these are border. So if you want to give the

border. So if you want to give the border uh just select it. And from here you can give the border. Look at that.

Yeah. And from here uh you can change the alignment like this. Okay. And this

is the vertical alignment. So if you want to give the vertical alignment, let's give like this. So it will vertical alignment. And here wrap text.

vertical alignment. And here wrap text.

So if you're using any image you can easily do the wrap text and here you can insert the numbers. So if you want you can insert the numbers and same thing

like uh currency symbol and here you can decrease or increase the decimal and here is the format option

and here chart images sorting. Okay. And

next is how to give the header footer page number and print. So just go to the file or you can go the direct print here. So I'm going to file and then

here. So I'm going to file and then select the printer. Under the printer you can select the your header folder.

Okay here. So select first I will select the header. Uh in the header you can see

the header. Uh in the header you can see we can add the page number. So here we have three different section. When you

click on the any section, it will give the option uh what you would like to insert like sheet name or workbook name, date, time or page number. So from here

you can add your text easily and in the other end I will add the page. Simply

click on page number and here type one.

Okay, I have given already one here and it will start the page number here.

Same thing work in the footer. So if you want to apply the footer just click on the footer and add your text and page number here. Okay, easy and simple. Come

number here. Okay, easy and simple. Come

back to the sheet and for print preview just press the control P and it will show the print preview here. Look at

that. Yeah, very simple.

And what I missing help okay I have tried to show everything. uh if I miss something or if you want to know something about your Zoho sheet so you

can ask me in comments and in the future I will make a separate video about its uh shortcut keys and how to work like a professional on sheet. Okay, until that

bye-bye take care and please do subscribe, like and share. Thank you

very much guys.