Print all worksheets in excel

 Here I have mention two way to print all worksheets of excel in one command.

1st Method : Right click on sheet name and Select All sheets. and then print command.

2nd Method : Give print command and select entire worksheet to print.

 

  Related Topics :

Formula to show day of the week in Excel

Formula to show day of the week in Excel

In excel we have TEXT function which can be used for showing day of week.

if want to show day of the week in excel then type below formula

=TEXT(A3,"ddd")

where A3 is cell that contains date  for which you want to show day of week.

if you want to show complete day of the week use below formula :

=TEXT(A3,"dddd")


TEXT() function is available in all the version of Microsoft office package.

 

Related Topics :

Print all worksheets in excel