Skip to main content

Sort numbers, digits or figures in Excel 2016


To sort numbers, digits, or figures in Excel 2016 is quite straight forward.

There are two ways to do it via the Home tab or Data tab.

What is found on the Home tab is sorting of alphabets or A-Z option which can easily be seen beside the auto-sum function which is on the right most tab of the ribbon by default.

Screen shot below shows the sorting functionality found in Home tab.



The other way to sort by numbers, digits or figures in Excel 2016 is to click on “Data” click on “Sort” then an option will appear to sort by smallest to largest or largest to smallest.

A screen shot below shows where to find the function.



That’s it hopes it helps to make thing easier.



================================
Free Android Apps:

Click on links below to find out more:

Excel Keyboard shortcuts guide

Linux Android App cheat sheet:

Catholic Rosary Guide  for Android:


Divine Mercy Chaplet Guide (A Powerful prayer):

Comments

Popular posts from this blog

Copy a single file using robocopy

Copy a single file using robocopy from a local folder to a shared folder on the network.
A simple rule of thumb before any disaster strike, don't interchange the source and the destination.

If source and destination is mistakenly reverse, files might get overwritten. To avoid any loss of data do a test with a dummy file to ensure things work perfectly.
Robocopy [source][destination]   [file to be copied]
robocopy c:\local_c_folder  \\PC_network\shared_folder   file_to_be_copied_xx.txt
The command will be completed successfully provided the network access right has no issues.

Robocopy works quite good on large files. A simple copy or xcopy command will also work but the speed might vary.

Robocopy is free it can be accessed from command line. No need to install the resource kit tool if the operating system is Windows 7 or newer version.

Copy files with selected file extension using PowerShell and Robocopy:

$extension = ('.pdf', '.jpg', '.txt')
gci d:\WorkFolde…

WMIC List printers

WMIC comes handy if you are a command line junkie.

To list printers via command line type:

wmic printer get name  = = = this will list all the printers installed on a workstation

To list the printer name and the port name of the printers, type this command:

wmic printer get name, portname

Type this command below to list the printer drivers:

wmic printer get name, drivername

To get the device id:

wmic printer get name, deviceid

You can deploy a batch file startup script to check which printer is installed on the computers and redirect the output to a shared folder.

PowerShell can also be used in conjunction with WMIC command:
http://quickbytesstuff.blogspot.sg/2015/11/powershell-list-printers-of-remote.html


To see more WMIC tips, click on WMIC label below.

Cheers!!!

Linux Android App cheat sheet:
https://play.google.com/store/apps/details?id=com.LinuxMobileKit