Networking Tips Tricks

Sometimes you may need to assign IP address to your colleagues, and the range of IP address may generate from 192.168.1.1 to 192.168.10.1 for instance. What can you do to generate them easily? Actually, the normal Auto Fill feature cannot work with this, or you can just create them manually by entering them in cells one by one? In this article we will show you how to write formula to make Auto Fill (drag down formula) feature work for IP address. Also  IP address  sorting is not possible with normal sort feature,  In this article we will show you how to write formula to make sort feature work for IP address. How to use formula more efficiently and save time when using Excel?

Problem Notified. Arrow keys scroll instead of changing cells in MS Excel Today I opened up Excel and stumbled up with problem. When i tried to move across cells with the arrow keys. Instead of moving across cells, the page was getting scrolled as if I was hitting the scroll bar with mouse. The active cell did not move, it would just scroll off the page.  Enter and tab key combination was still work to move the cell down/to the right, respectively (and shift enter moves up). When I go into a cell and try to enter a formula, it still scrolls instead of moving to the reference cell when pressing the arrow keys (but I can select the cell with the mouse). I played with the options but there was nothing that I could find. Does  anyone experienced this before? Any advice would be appreciated. Answer: The symptom above is Behavior of Excel when scroll lock is ON. When scroll lock is On; you can not not change the cell with arrow keys instead it will scroll page.  c...