00:00If you have a dataset table that looks like this and you need to add a subtotal line that
00:04will make it look something like this, well stay tuned for a quick demonstration on how
00:08this can be done.
00:10Select the cells like this and press Ctrl G to open a go to window.
00:14Click on special, select constant and click OK.
00:17And now you're gonna press Ctrl Shift plus and then you're gonna select entire row and
00:21click OK.
00:22And this is gonna insert the subtotal line for you.
00:24Next, you're gonna select all the sales value.
00:26Make sure you select the very last one as well.
00:28Press Ctrl G again, special, blanks and OK.
00:32Make sure that the last line is also selected.
00:34If not, hold down Ctrl and left click on your mouse.
00:37Now press alternate equal to calculate your subtotal.
00:40Next you're gonna make it more readable.
00:42Press Ctrl B to make it bold.
00:44Alternate HFG to make it bigger.
00:47And to draw lines around it, press alternate HDD.
Comments