How to Multiply Columns in Excel
How to Multiply Columns in Excel
How to Convert Excel Sheet to Google Sheet
Hello friends in this video I will show how to convert your Excel worksheet into Google Sheets so firstly open your Excel file and save it on your desktop or in your
laptop give any name and save
it now open any browser and
here click on this dots and open Google
Drive now here click on new file upload
and select your
Excel now complete this uh uploading process once this complete click on
recent now it’s a file click on these three dots
and open with so here you can select Google
Sheets now Google Drive will convert your Excel worksheet into Google
Sheets
now here you can make changes as your
requirement now click on file and here you can save as Google Sheets click anyway contrl C crl a select all then contrl
C select entire your Excel worksheet control
C then here control
V so this is the second method you can apply then file and download and here you can download is Microsoft Excel Open document PDF web
page you can import from
here go drive this is the third method then
insert here you can create new spreadsheet insert new
seets then import
data.
How to convert column to comma separated list in Excel
hello guys in this video I will show how to convert columns into CSV in Microsoft Excel so there are two formula you can try any
formula first Formula equal sign type text
join now this quotation mark and comma again this double quote and
comma Now here you can select true or false true to ignore empty cells false to include empty cells you can select any option
now
comma and select data closing bracket and press
enter so this way you can convert column into CSV uh second method
equal and type
conate this one
selected and select data now and symbol now this symbol then comma again this symbol and closing bracket so this is the formula press enter so guys as we can see this is the formula to
convert your column
into CSV s you can convert row into CSV using this formula I will show you
example there you
have some data
here you have some data and you want to convert this row into CSV click here type equal
sign C double click on it and select this data then end
now this double quat comma double quat and closing bracket and press
enter so thanks for watching comment this video useful for you.
How to Recover Excel File Not Saved or Lost
hello everyone today in this video I gonna to show you how to recover unsound file in Microsoft Excel it’s very easy and is simple let’s start firstly open Microsoft Excel now click on black workbook now go to file and here you will find a option recover unsaved workbooks click this one so you will find unserved your recover file from here and if you will not find here so use another method tencel this go to file on now click on options
[Music] now left side click on sale so in this dialogue box you will see auto recover file locations so copy this one highlight this now ctrl C now click on file explorer and in File Explorer you go to here highlight this one and ctrl V
click on this arrow so here you will find your lost or unserved workbooks for Excel so actually I have the two files choose and select which you want here is the debt and here is the name so for example this one click this one so you can see the porte-cochere click this now you will see this message no error over detected in report and no repair or necessary click this okay so you get back your unsaved file if you want to edit anything so your choice but you have to do now save this file and change the location for this file so simply go to say oh sorry go to save as and choose location so I will go to desktop and give the name my report one and make cell so by this simple method you can recover your unsaved or launched file in Microsoft Excel program and no matter any power any version of Microsoft Excel these settings for recovery are similar I hope this video will be useful for you and you know how to recover in Excel I request you don’t forget to subscribe my channel thanks for watching this with you.
Fix There isn’t Enough Memory to Complete this Action in Excel
How to Hide Formulas in Excel [Quick and Easy]
in this video I will show you how to hide formulas in Microsoft Excel or once we click it we can see formula so to hide this formula
firstly select it
now right click on it format cells
and in protection select hidden unselect block
then click on OK
now click anyway
now once we click on it still it will appear now next step select these cells now right click on it
format cells now select unlocked then click on OK
now third step select review
protect sheet
enter the password if you need then click on OK
now once you click on this formula bar so formula will not appear
and once we change the value so it will reflect here but formula is hidden so this area is editable
user and people can change value here but they are not able to see the formula which is used here
like this to remove this setting again click here review and click on unplotted sheet it will ask password so enter the password now once you click on it so formula will appear
so thanks for watching this is the way to hide formulas in Microsoft Excel.
How to Create a Table in Excel Spreadsheet Basics
in this video, I will show you how to insert a table in Microsoft Excel so click on Insert and Table and here uh select Where is the table the
data click here if your table has the header and click on okay need more so firstly select CES then insert
and so select here and you can make it more just drag and [Music]
drop like
these also guys you can insert a table and
worksheet so select it and
table first select this corner table and click on okay if your table has a header selected then
okay so now your Excel worksheet will appear as a table and here you can change size color style
everything table properties you will see some more options you can remove
a header can add or remove bent rows
so thanks for watching the comment this video useful for you
How to Multiply Columns in Excel
How to Multiply Columns in Excel
hello, dear, you are welcome to this channel today in this video we going to learn how to use the multiplayer formula in the Microsoft Excel program here is some basic data for using the formula multiplied here and play name here is the time of their work weeks and hours per week now we will get the total hours so we will use multiple a formula click here enter equal sign now enter be to
multiply sign rc2 Namit and training so you will get the result now select all the columns and press control D on the keyboard another way to use the multi-player formula in Excel firstly select a cell where we went through multiple results and enter equal sign now type product
multiplayer all the numbers given as arguments in double-click this command indicates that you want to multiply items together now give the seldom, in this case, be true now enter: and select now c2 now enter brackets now Mac enter so you will get the result for this cell now select all the column and press enter D so we’ll get the result for all columns thanks for watching this video