Showing posts from October 28, 2014


How to prevent ending up at a CCMA for using incorrect recruitment procedures.

If you're only hiring people who're from designated groups, and you've stated this in your employment equity plan, you must include this in your job ad. At the top of your ad, you must state 'Affirmative Action position' or at the end of your ad, insert a phrase such as: 'The organisation is an equal-opportunity  employer; however, preference will be given to Affirmative Action applicants'.
Do this so the candidates who do not fit the specific requirements don't waste time applying for the job. This will also help you get the right candidates for the right job.


To unhide multiple hidden columns:

In Step 1 above, type a reference to the columns in the Name box.

For contiguous columns, enter the top left and bottom right cells separated by a colon (e.g.. D5:E5).

For non-contiguous columns, enter a cell from each column you want to unhide separated by a comma (e.g. B5,G5).

MS EXCEL TIPS - Unhide a Single Column from a Group of Hidden Columns

QUESTION: "Is there an easy way to unhide a single column when multiple columns are hidden?"

SOLUTION:If you have a multiple rows or columns hidden and you need to unhide just one, there's no need to unhide them all and then re-hide all except the one you want. To unhide a single column:

In the Name box (the white space to the left of Formula Bar), type a cell reference (e.g. D5) for any cell in the hidden column and press Enter. This will select that cell even though it's in a hidden column;Next, from the Home tab, click the Format command, point to Hide & Unhide, then Unhide Columns.